For a few KPIs the total gets not calculated right in bex query.

[former_member671877]

The "overall result" for a few key figs is wrong. What can I check or change? those columns have if else formulas .

[DebjitSingha]

without key details, this questing is vague. Please add details before you can get any help.

[former_member671877]

screenshot.png

My column "AC" is having a formula(X column* Y column) so in Overall result section its showing multiplication instead og Whole column's sum. So basically I want to show summation of whole column's value(i.e. Summation of column AC).....

[DebjitSingha]

use insert images instead of insert attachment.
add BEx snapshot, total row formula (if any), Add current output and highlight what you see.

[former_member671877 · Accepted solution]

I used summation and it worked. Thank you!

[DebjitSingha · Accepted solution]

Good work!
feel free to close the thread as well.