topic Re: If Condition equals true - -> Sum Column of same ID in App Development

If Condition equals true - -> Sum Column of same ID

rohi__ — Sat, 16 Nov 2024 18:23:57 GMT

Hello everyone,

I want to sum up the scrap from all the orders that have gone through all the operations.

I have tried as follows:

sum(aggr(max({<OP= {'40'}, Status = {'True'}>} Scrap), Order))

so I only get the one row of data where the condition is true. But I want to know the order ID where the last operation is true and then add up the column scrap.

does anyone have an idea of how to do this?

thanks a lot in advance!

Order	OP	Good	Scrap	Status
1	10	100	0	True
	20	100	0	True
	30	90	10	True
	40	90	0	True
2	10	70	0	True
	20	60	10	True
	30	60	0	True
	40	50	10	False

the solution would be 10. because only order 1 is finished yet.

Re: If Condition equals true - -> Sum Column of same ID

Taoufiq_Zarra — Wed, 08 Jul 2020 09:23:42 GMT

Hi,

If I understood correctly, one solution :

=Sum({<Order={"=Match(right(concat(OP&Status,''),6),'40True')>0"}>} Scrap)

output :

Re: If Condition equals true - -> Sum Column of same ID

rohi__ — Mon, 13 Jul 2020 12:56:07 GMT

HI @Taoufiq_Zarra ,

thank you for your fast reply!

when I implement this formula it only evaluates the data series where this condition is true. but I need the sum over the whole column scrap.

thanks again!

Re: If Condition equals true - -> Sum Column of same ID

Kushal_Chawda — Mon, 13 Jul 2020 14:41:03 GMT

try this

sum({<Order = p({1<OP={'40'},Status={'True'}>}Order)>}Scrap)