How to calculate percentage on summed values

Stimulsoft Ultimate discussion
Post Reply
bahiapt
Posts: 22
Joined: Mon Jul 06, 2020 4:13 pm

How to calculate percentage on summed values

Post 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
Lech Kulikowski
Posts: 6193
Joined: Tue Mar 20, 2018 5:34 am

Re: How to calculate percentage on summed values

Post 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.
Post Reply