How to calculate percentage on summed values
Posted: Thu Apr 08, 2021 1:51 pm
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.
Warm Regards,
Daniel
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