Sum with Variable

[Anonymous]

Hi All

I am trying to sum Sales for current month previous month and 2 months ago

I have variables for this and am doing the following

=(Sum({<$(vCurrentMonth) Collections))

=(Sum({<$(vPreviousMonth) Collections))

but this does not work any idea how to do this please?

Thanks alot!

[kaushiknsolanki · Accepted solution]

Hi,

Try this way.

Sum({<Month = {"$(vCurrentMonth)"}>}Collections)

Sum({<Month = {"$(vPreviousMonth)"}>}Collections)

Regards,

Kaushik Solanki

[Gysbert_Wassenaar]

Maybe like this:

=(Sum({<Month={$(vCurrentMonth),$(vPreviousMonth)}>} Collections))

[MayilVahanan]

HI

Try like this

Sum({<Month={$(vCurrentMonth),$(vPreviousMonth), $(v2MonthAgo)}>} Collections)

[Anonymous]

Thanks All

This has worked !!!

Thanks

Kaushik Solanki