formulas

walid1 — Wed, 05 May 2021 12:44:46 GMT

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

Re: formulas

eddie_wagt — Wed, 05 May 2021 13:30:14 GMT

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

topic Re: formulas in App Development

formulas

Re: formulas