Page 1 of 1

How to calculate percentage on summed values

Posted: Thu Apr 08, 2021 1:51 pm
by bahiapt
Hi all,

I am trying to build an expression (see below) of aggregated values, now it's obvious i am doing something wrong because is not giving me a correct result, appreciate if someone can point me in the right direction.

Code: Select all

{Sum(ObjectDetails_data.Net_Billed)-Sum(ObjectDetails_data.Costs)} / {Sum(ObjectDetails_data.Net_Billed)} *100

Warm Regards,
Daniel

Re: How to calculate percentage on summed values

Posted: Fri Apr 09, 2021 1:32 pm
by Lech Kulikowski
Hello,

Please check the following expression:
{(Sum(ObjectDetails_data.Net_Billed)-Sum(ObjectDetails_data.Costs)) / Sum(ObjectDetails_data.Net_Billed) *100 }

Thank you.