Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Perhaps like this: sum({<date={"=Day(date)=1"}>}sales)
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..
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.
Hi Gysbert,
Can i have the same logic instead of month start to month end.
Thanks..
Something like this:
Sum({<[Reported Date] = {"=Day([Reported Date])=Day(MonthEnd([Reported Date]))"}>} [Invoice Total Line Amt])
What logic? What do you mean 'month start to month end'? Which month for example?