Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want make a sum in a expression but a join in my load script duplicate some data, for example
id;mynumber;otherid,somedataofotherid
1;25;87;somedata1
1;25;88;somedata2
How to sum mynumber and have 25 for result, I want to ignore otherid and somedataofotherid ? I have also lot of filter and i use lot of if to filter my data
Perhaps it's not possible ?
Thanks in advance
Christophe
Try sum({<otherid=,somedataofotherid=>}distinct mynumber)
Try sum(aggr(sum(distinct mynumber),id_statut,otheridtokeep))