Skip to Content
0
Former Member
Nov 07, 2005 at 05:35 PM

BW Query: Formula for calculated key figure

34 Views

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