Calculate Grand Total differently due to flipped sign

[smileamile2]

I have revenue and expenses broken out into groups. The "Amt" column is the original amount with revenue as a debit, so the signs are negative. I created a calculated column "Amt Flipped" to flip the sign for that group. This works fine so it reads more like a P&L, with revenue and expenses as positive values.

However, the built-in functionality for the grand total is to just sum up the column, which doesn't work for my scenario. Can I add logic in to handle this? Do I create my own Total row? The January "Amt Flipped" column total should be -$2.4M, adding up the same way (without sign flipping logic) "Amt" column is.

[Anonymous]

Hi @smileamile2 

Previously, I raised some doubts based on the questions you provided, but you did not reply. Has your problem been solved ?

If not, please give a detailed explanation based on my previous questions.

If it has been solved, provide your method for the problem then consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Ailsa Tao

[Anonymous]

Hi @smileamile2 

Please correct me if I wrongly understood your problem .

“The January "Amt Flipped" column total should be -$2.4M” ,so the value should be same with the total of Amt without “$” ?

I have another question is how did you get $2405524.14 , I tried it with the data you provided, but the result did not match .So could you provide the calculation rules ?

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FrankAT · Accepted solution]

Hi @smileamile2 ,

watch the very instructive video from Matt Allington to build a P&L: https://exceleratorbi.com.au/build-a-pl-with-power-bi/ I think here you get your answer.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)