Thomas Frobieter
I don't get the idea of this formula editor. I can't create complex formulas because the automatism is rapidly fucking up my formulas by trying dumb autocompletes. This is SO frustrating. Even if I build the formula outside and paste it into the formula editor, it fucks up my formula. That's the function I pay 10€ a month, great. I've better used VUE and write a simple custom application in the time I fought against this editor.
Try to paste this:
IF(field("Gewerk") = 'Solaranlage', 0, (ROUND(SUM(field("Summe Brutto")/field("MwSt_Bruch")),2)))
Result:
IF(field("Gewerk") = 'Solaranlage', 0, (ROUNDfield("Summe Brutto")tfield("MwSt_Bruch")uch")),2)))
Another thing
is, that the if clauses don't work like in regular programming languages. Trying to prevent a division by zero using a field value:
field("MwSt_Bruch") could be 1.19 or 0.
field("Summe Brutto") is a currency field (€ decimal)
IF(NOT(field("MwSt_Bruch")), field("Summe Brutto"), 'NOT SOLAR') => Works with MwSt_Bruch is 0, it prints field "Summe Brutto"
IF(NOT(field("MwSt_Bruch")), field("Summe Brutto"), ROUND(field("Summe Brutto") / field("MwSt_Bruch"), 2)) => Does not work, because for whatever reason, the else part is still executed while the if part is true => Division by zero.
So I ended up hard-coding field("MwSt_Bruch") in the else part, what makes it FINALLY work for the majority of cases. But this really sucks.
IF(NOT(field("MwSt_Bruch")), field("Summe Brutto"), ROUND(field("Summe Brutto") / 1.19, 2))