Expressions calculation

[#1]

Hi Experts

in my qvw i am calculating AREAMANAGER count against REGIONMANAGER to calculate targets

i am using this expression to count that

=SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME))

the values yielding are correct but there is a new condition like if AREAMANAGER count exceeds 19 for a REGIONMANAGER then it should write as 19

i have two REGIONMANAGER exceeding 19 AREAMANAGER

how can i change this expression

please suggest

[sunny_talwar · Accepted solution]

May be this:

=If(SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME)) >= 19, 19, =SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME)))

[sasiparupudi1]

if (AGGR(count(AREAMANAGER),REGIONMANAGER)>=19,19,SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME)))

[#4]

HI Sunny

Thanks

=If(SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME)) >= 19, 19, SUM(AGGR(AREAMANAGER,REGIONMANAGER,BUSINESSMANAGER,BRANCHNAME)))

after removing the = it worked perfect

Expressions calculation