how it works here

[soniasweety]

Hi all,

how this variable works

vNoOfMonthsDisplay  =12

vMonth=Num(AddMonths(Date(Max([Month Year])),-vNoOfMonthsDisplay))          ==this how works?

[sunny_talwar · Accepted solution]

It takes the Max(Month Year) and takes it back 12 months. Not exactly sure what you are not clear about...

[PrashantSangle]

If you want to learn exact functionality of each function which use in your expression go to help menu

max()

addMonths()

date()

and Num()

Note : In your expression you can avoid Date()

Regards,

[shiveshsingh]

=Num(AddMonths(Date(Max([Month Year])),-12))  

You are pulling max from the [Month Year] field and then going 12 months back, post this you are converting it to Num format.

[Anonymous]

Hi,

With my understand of expression, The code will roll-out for 12 months.

Ex: If you want to show case last 12 months trend from current month this code will helps.

Thanks,

Venkata Sreekanth