Expression

[upaliwije]

Hi Friends

In my QV document I have a straight table where the Expression for Calculated Premium field does not show results as shown below

I have attached my document. Pls advise me to correct my error

[prma7799 · Accepted solution]

Please  try like

=if (Aggr(IF(MaxString({<[BCOD]=P([BCOD])>}[BCOD])=[BCOD],[BCOD]),[BCOD])=BCOD,

(num(if (Aggr(IF(MaxString({<[BCOD]=P([BCOD])>}[BCOD])=[BCOD],[BCOD]),[BCOD])=BCOD, sum(PREMIUM)),'##,##0')

-

if (Aggr(sum({$<CC_CODE={'CC*'}>}PREMIUM),BCOD)>0,Aggr(sum({$<CC_CODE={'CC*'}>}PREMIUM),BCOD),0)

),sum(PREMIUM))

[Anonymous]

Can you tell us what is it that you want to be displayed in the last column?

[Anil_Babu_Samineni]

As always, try to ignore direct field names. And use Simple aggregation Sum() for your data point.

[Anonymous]

This seems to be the correct answer you are looking for...

if (Aggr(IF(MaxString({<[BCOD]=P([BCOD])>}[BCOD])=[BCOD],[BCOD]),[BCOD])=BCOD,
(num(if (Aggr(IF(MaxString({<[BCOD]=P([BCOD])>}[BCOD])=[BCOD],[BCOD]),[BCOD])=BCOD, sum(PREMIUM)),'##,##0')
-
if (Aggr(sum({$<CC_CODE={'CC*'}>}sum(PREMIUM)),BCOD)>0,Aggr(sum({$<CC_CODE={'CC*'}>}sum(PREMIUM)),BCOD),0)
),sum(PREMIUM))

[Anonymous]

Please close this thread if your problem is solved

[prma7799]

Already Closed ...

[upaliwije]

already closed