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 » 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.

Code: Select all

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

Warm Regards,
Daniel
Lech Kulikowski
Posts: 3492
Joined: Tue Mar 20, 2018 5:34 am

Re: How to calculate percentage on summed values

Post by Lech Kulikowski » Fri Apr 09, 2021 1:32 pm

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