Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to sum a field with conditions but the funaction does not work. Does anyone know what i do wrong? This is the formula:
=sum({$<[Data-totaal.betreft]={'omzet'}>}[Data-totaal.omzet/kst])
Hello @walid1 ,
It is hard to guess why it is not working without seeing the data or a good description of what you are trying to achieve. Better is to share a snippet of data. I tried to replicate your data and the expression works.
LOAD * INLINE [Data-totaal.betreft,Data-totaal.omzet/kst
omzet, 1000
kosten, 200
omzet, 3000
blabla, 100
];
Regards
Eddie