where to put variable

[kunkumnaveen]

Hello All,

i have  a variable

set vdate= 'date=,week=';

and i have a exp:

Num(sum(  aggr ( avg(units),Date, top,Work )) ,'#,##0')

i want to add a varible in to this exp ,i tried over here  which is not working 

Num(sum(  aggr ( avg(units),$(vdate),Date, top,Work )) ,'#,##0')

so where should i need to put this variable so that if i select any date  it should not reflect my chart

thanks

naveen

[sunny_talwar · Accepted solution]

May be like this:

Num(Sum({<$(vdate)>} Aggr(Avg({<$(vdate)>} units), Date, top, Work)) ,'#,##0')

[kaushiknsolanki]

Try this.

Num(sum( {<$(vdate)>} aggr ( avg({<$(vdate)>}units),Date, top,Work )) ,'#,##0')

Regards,

Kaushik Solanki

[miguelbraga]

Hey there,

Why not the vDate Variable be something like this:

vDate = Max(Date).

This way you can get the values from your selected Date.

Hope this helps you, if not please tell me,

Regards,

MB