Variable

[nareshthavidishetty]

Hi,

I need to create an dynamic variable which need to show sum(data) for only 1st of every month which would starts from FEB 2016.

Like sum(sales) where date = 03/01/2016(Mar),04/01/2016(Apr),......

Thanks..

[Gysbert_Wassenaar]

Perhaps like this: sum({<date={"=Day(date)=1"}>}sales)

[nareshthavidishetty]

Hi,

I have used the below logic but it is giving value.But here i need for all the months where yearstart = Feb 2016.

sum({<[Reported Date]={"=Day([Reported Date])=1"}>}[Invoice Total Line Amt])

Thanks..

[vishsaggi]

Can you send us the screen shot of your expected output.? Or issue you are having. Gysbert's expression should give you the 1st of every month.

[nareshthavidishetty]

Hi Gysbert,

Can i have the same logic instead of month start to month end.

Thanks..

[sunny_talwar]

Something like this:

Sum({<[Reported Date] = {"=Day([Reported Date])=Day(MonthEnd([Reported Date]))"}>} [Invoice Total Line Amt])

[Gysbert_Wassenaar]

What logic? What do you mean 'month start to month end'? Which month for example?