Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
sample data
when i select max date i was suppose to get 500 as value but i am getting 0
Varibles:
vMindate = 3sep;
vMaxdate = Date;
expression:=sum({<Date={"$(vMindate)"}>}value) = 100
sum({<Date={"$(vMaxdate)"}>}value) =500 (Not Working)
wats going wrong in my above statement?
thanks
Have a look at the attachment.
no..getting same o/p 0
Is that date format? Can you share the sample qvw?
Hello,
u can create
in script
load *,
MONTH(Datefield) as month
day(datefield) as day
den u can use variable
Have a look at the attachment.
try this
=sum({<Date={"$(=$(vMaxdate))"}>}value)
=sum({<Date={"$(vMindate)"}>}value)
Hi,
It is help full for you.