If condition with dynamic value

[mahfuz]

i want to check two field value and sum another field.

if ( count x = count y) then sum(distinct amount)

How can i do this ?

[Taoufiq_Zarra]

@mahfuz  in Script ? can you upload a sample data and the expected ?

you can use for example

Data:

load

...

left join load ..

if ( count x = count y) then sum(distinct amount) resident Data group by ...

[mahfuz]