formulas

[walid1]

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])

[eddie_wagt]

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