Hi!
I want to calculate a key figure in the following way:
if a value is "0", then bring out "1"
otherwise bring out the value of the field
bring out "blank" when the value of the field is "blank"
I created the following formula but the system brings out a "1" even the value is "blank":
( 'Headcount FTE for Fu' == 0 ) * 1 + ( 'Headcount FTE for Fu' <> 0 ) * 'Headcount FTE for Fu'
Is there a way to bring out the correct firuge?
Thanks a lot
br
Jörg