if(aggr(sum(...

[carolin01]

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

[MK_QSL]

What is your expression after replacing the Variables?

[carolin01]

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

[MK_QSL]

May Be

SUM(Aggr(IF(SUM($(=vRevenueTotalMax))>5000, SoldToBusinessPartner),SoldToBusinessPartner)

[carolin01]

Unfortunately no. The dimension then indcates "// Error in calculation"

[jagan]

Hi,

Can you attach sample file and your expected output?

Regards,

Jagan.