I am experiencing lot of problems when dealing with indicators and blanks.
The summary is:
- Same indicator has different behaviors when showing alone or with others. Alone is showing blank when the value is blank. But when other indicators are included in the same query, the same indicator gives zeros instead of blanks.
- Indicators including multiplication of values show zeros, even if one of the multiplicand is blank.
- if sentences in expression do not allow to give a blank output. In 2.32 the expression is considered as malformed. In 2.30 the expression is accepted but a NaN is returned instead of blank. In 2.30 is not possible to do any workaround since the isNull, isNotNull functions are not working at all.
Al that is very frustrating, thank you for helping !
Here some screencaptures, more details in the JIRA tickets.
Data in the system:
Test1: Indicator is the value of TEST1 Male. Blank it’s ok
Test1b: Indicator is the same. But now it’s showing 0 instead of blank!
Test2: Indicators are the multiplication of Male and Female. The result is ok for TEST1 (2), but not for TEST2 dataElement (o instead of blank!)
Blanks are not expected as output of indicators…