Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have this formula that works great.
=num(sum(aggr(count(distinct FEC),CTNO))
,FormatoNum)
now i need to put set analysis with a variable that selecet a specific day.
vDONE= date(max(BILL))
please help how can i do this?
Something like this?
Num(sum(aggr(count({<date = {$(vDONE)}>} distinct FEC),CTNO)) ,FormatoNum)
Cheers,
DV
Something like this?
Num(sum(aggr(count({<date = {$(vDONE)}>} distinct FEC),CTNO)) ,FormatoNum)
Cheers,
DV
I don´t know why but it not working,
Thanks for your reply!!
Regards.
Define your variable as =date(max(BILL)) so the max date is calculated outside the context of the chart. Also replace date in <date = {$(vDONE)}> with the name of your date field and make sure that the max date calculated in your variable has the same date format.
to be exacly is
=num(sum(aggr(count(distinct BILL),CTNO))
,FormatoNum)
now i need to put set analysis with a variable that selecet a specific day.
vDONE= date(max(BILL))
so it will be
Num(sum(aggr(count({<BILL= {$(vDONE)}>} distinct BILL),CTNO)) ,FormatoNum)
that´s my actually formula than not work
Deepak Vadithala Thaths right. ( " ) was the problem!!
regards.
=Num(sum(aggr(count({<FEC= {"$(vDONE)"}>} distinct FEC),CTNO)) ,FormatoNum)