Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this:
Num(Sum({<$(vdate)>} Aggr(Avg({<$(vdate)>} units), Date, top, Work)) ,'#,##0')
May be like this:
Num(Sum({<$(vdate)>} Aggr(Avg({<$(vdate)>} units), Date, top, Work)) ,'#,##0')
Try this.
Num(sum( {<$(vdate)>} aggr ( avg({<$(vdate)>}units),Date, top,Work )) ,'#,##0')
Regards,
Kaushik Solanki
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