topic Re: Check if different row contains same value in columns in App Development

Check if different row contains same value in columns

FelipeG — Sat, 16 Nov 2024 01:19:26 GMT

Hey guys! Hope you can help me with these problem i've been struggling with...

I have a table of operations:

I want to see all the operations that a company has done against themselves. In the example above I would end with:

1	09/10/2020	Apple	Buy	100
1	09/10/2020	Apple	Sell	100

I can't mess with the script in this particular case, needs to be some sort of Set Analysis operation or similar.

Would really appreciate some help!

Kushal_Chawda — Fri, 09 Oct 2020 13:59:20 GMT

@FelipeG try below

=sum({<Company=p({<[Op. Type]={'Buy'}>})*p({<[Op. Type]={'Sell'}>})>}Amount)

FelipeG — Wed, 14 Oct 2020 15:19:14 GMT

It didn't work. Shows the same value than sum(Amount). Any idea??