Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can anybody help me witht he correct variable syntax in this aggr-statement:
=if(aggr(Sum($(=vRevenueTotalMax)'$(vLagerSmaler)'&'$(vTopCustomer)',SoldToBusinessPartner)))
The Variable vLagerSmaler should give the user the option to choose > or <, the vTopCustomer should give the possibility to enter a value. This is used as calculated dimension to enable the user to filter the list of customers.
Best regards
Carolin
What is your expression after replacing the Variables?
Hi,
the Statement without variables would be e.g.:
=if(aggr(Sum($(=vRevenueTotalMax)),SoldToBusinessPartner)>5000,SoldToBusinessPartner)
But also this doesn´t give me the result that I want...
Carolin
May Be
SUM(Aggr(IF(SUM($(=vRevenueTotalMax))>5000, SoldToBusinessPartner),SoldToBusinessPartner)
Unfortunately no. The dimension then indcates "// Error in calculation"
Hi,
Can you attach sample file and your expected output?
Regards,
Jagan.