VcurrentYear

[#1]

Hi all i have a variable  which like this

vCurrentMonth= Max[Month No]

And month No is a column name which has 4,5,6,7,8,910

Now i want to know what does this variable means ? and what does it do

2.

What doeas the below expression does can some one explain me please

=Sum({$<Year={$(=Max(Year))},[Month No]={$(=vCurrentMonth)}>}[Sales Amount])

Thanks in advance

[alexandros17]

vCurrentMonth= Max[Month No]

this variable returns the maximum value for the column 'month No'

=Sum({$<Year={$(=Max(Year))},[Month No]={$(=vCurrentMonth)}>}[Sales Amount])

this expression returns the sum of Sales Amount where Year is the max year selected and month no is the current month

[its_anandrjs]

Hi,

The expression calculates [Sales Amount] for current month or current year if the max year in table is 2015 month is Jan

Regards

Anand

[nikhilgarg]

By your expressn:

It will return the Sum of [Sales Amount] where year is equals to maximum of year and Month is MAximum of month as in your case if Month's values are:

1, 2 , 3 4, 5 , 6 , 7 ,8 9, 10 then [Month No]={$(=vCurrentMonth)} will return Month = 10 always.

thanks

[krishna20]

Hi Wrestler,

vCurrentMonth= Max[Month No]....(Month No)->4,5,6,7,8,910

This will takes maximum value from the Month No field.I.e; it will retrieve 10 from the field.

=Sum({$<Year={$(=Max(Year))},[Month No]={$(=vCurrentMonth)}>}[Sales Amount])

This shows the total sales amount of  maximum year from your year field and Maximum month from your Month Field.

Regards

Krishna