Skip to main content

Hi Team,

 

How to create calculation previous month sales i need every month 1st &2nd & 15th &16th. current month 1st to till date.

Please help me how to create calculation.

 

Please find the attached file.How to create calculation previous month sales i need every month 1st &2nd & 15th &16th. current month 1st to till date.Regards,

Tgv

3 answers
  1. Nov 29, 2023, 4:40 PM

    Well, since that's just the same image as in your question, a little more clarification might have helped, but I'll take a guess.

    DATEPART('day',[Order Date1]) IN (1,2,15,16)

    OR

    DATETRUNC('month',[Order Date1]) = DATETRUNC('month',TODAY())

0/9000