topic Re: How to sum values based on another field value in App Development

How to sum values based on another field value

mfarslnn — Wed, 21 Nov 2018 14:20:31 GMT

Hello,

I have a table like this;

field - value
a - 10
a - 15
b - 5
c - 20
c - 30
c - 8

What i want to do is sum up the values of a and c fields. But while summing up the a values i want to subtract b values from the sum of a. For example i want to see a = (10+15-5)=20 and c = (20+30+8). That's what i want to see as a result.

Any help would be appreciated.

Thanks.

Re: How to sum values based on another field value

Thiago_Justen_ — Wed, 21 Nov 2018 14:26:29 GMT

Sum(a)-Sum(b)+Sum(c)

Re: How to sum values based on another field value

mfarslnn — Wed, 21 Nov 2018 14:29:49 GMT

This gives 25-5+58=78 which i dont want to see. I want a result set like this;
a - 20 (10+15-5)
c - 58

Re: How to sum values based on another field value

Thiago_Justen_ — Wed, 21 Nov 2018 17:07:48 GMT

Create a table with:

Dimension: Valuelist('A','C')

Expression: If(Valuelist('A','C')='A',RangeSum(a,-b),Sum(c))

Re: How to sum values based on another field value

Wlad_Masi — Wed, 21 Nov 2018 17:13:00 GMT

(A-B): Sum({<Field={'a'}>}Value) - Sum({<Field={'b'}>}Value)

(C): Sum({<Field={'c'}>}Value)

Re: How to sum values based on another field value

PuriVelasco — Thu, 03 Dec 2020 16:43:11 GMT

Hello,

do you resolve your problem? I have a similar question.

Thank you very much.