i'm woundering how to solve the issue that 0 values calculated in Rules are still get showed in a Zero suppressed View, i found in the docs i could assing the "Undef" Value (which means no data input and not a real 0 (it would be data input), if i understand it right).
But now the Value get shown as #N/A, if i use 0 then "undef" it get shown in the zero suppressed view.
How can i solve this?
The Rule Code:
Code: Select all
['Abwesenheiten rMA', 'HR'] = IF(ELISPAR('Kennzahlen Personaleinsatz-Reporting', 'Brutto Einsatz rMA', 'Abwesenheiten rMA') = 1, UNDEF, Continue);
#Or
['Abwesenheiten rMA', 'HR'] = IF(ELISPAR('Kennzahlen Personaleinsatz-Reporting', 'Brutto Einsatz rMA', 'Abwesenheiten rMA') = 1, 0, Continue);