Hello experts,
I have this QM formula:
IF C020 > 0 AND C040 > 0 THEN (C020C040)/2 ELSE C020C040
For any values in characteristic 20 and 40, the formula is working. But if one of them is not filled so the formula didn´t return any value.
Some suggestion to solve this?
Thank you in advance.
Regards,
Charles Oliveira
Hi Oliveira,
The formula which you have written is absolutely right,there is nothing wrong in it.
In order to calculate the formula one of the characteristic is to be given the value of 0 and has to be evaluated.
Formula works only if the characteristics are valuated.So you have to valuate all the characteristics.
Hope this is helpful.
Regards
Sreenath
Add a comment