Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
My pivot table like this,
BCOD | CRE_CODE | REF_NO | PREMUM | BRO_COMM | BRO_ORC | AGE_COM | AGE_ORC | GRO_COM | GRO_ORC | DIRECT ME | TOT_COM | DIFF | TOTAL |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BA00 | C0003990 | BA0014D0028258 | 53035 | 0 | 0 | 7289 | 0 | 0 | 0 | 0 | 4638 | 0 | |
C0005750 | BA0014D0028454 | 27100 | 0 | 0 | 3735 | 0 | 0 | 0 | 0 | 2380 | 0 | ||
C0008186 | BA0014D0028343 | 15195 | 0 | 0 | 2024 | 0 | 0 | 0 | 0 | 1265 | 0 | ||
BA0014D0028484 | 53195 | 0 | 0 | 7549 | 0 | 0 | 0 | 0 | 4889 | 0 | |||
DIR | BA0014D0028243 | 11773 | 0 | 0 | 1637 | 0 | 0 | 0 | 0 | 1048 | 0 | ||
BA0014D0028344 | 16400 | 0 | 0 | 2185 | 0 | 0 | 0 | 0 | 1365 | 0 | |||
6297 | BA0014D0028454 | 27100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 575 | 0 | ||
54781 | BA0014D0028455 | 6495 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 625 | 0 | ||
Total | 183193 | 0 | 0 | 24419 | 0 | 0 | 0 | 0 | 16785 | 0 |
So I want to calculate "AGE_ORC" for the ME codes.
The expression i used there is shown below. Even the expression shows the status "OK" , relevant calculation not done.
sum({<Cat={'AG'},POSI={ME}>}(COM_PRE*AG_COM_ORC+SR*AG_RS_ORC+TC*AG_TC_ORC))/100
Please can any one help me in this regard, Early reply highly appreciated.
Priyantha.
Hi,
Try this expression
=sum({<Cat={'AG'},POSI={'ME'}>} (COM_PRE*AG_COM_ORC+SR*AG_RS_ORC+TC*AG_TC_ORC))/100
If not working attach sample file.
Regards,
Jagan.
Dear Jagan,
The same formula i have already applied (see the above post)
Hi,
It is difficult to give answer without sample file, your expressions seems to be correct, you really have values for this expression? Check this expression in Text object whether you are getting any value.
=sum( (COM_PRE*AG_COM_ORC+SR*AG_RS_ORC+TC*AG_TC_ORC))/100
If you are getting value then there is no records for Cat='AG', POSI='ME', if possible attach the file.
Regards,
Jagan.
Dear Priyantha ,
your question is not clear so elaborate the problem and give sample in excel.
Regards
Vimlesh Gupta