Skip to Content
0
Apr 01, 2016 at 02:44 PM

KF Calculation if one of 2 inputs are not initialized

282 Views

Hi,

I have a calculation that that selects the higher value between 2 KF.

The calculation works only if both KF are initialized, I would like for it to work even if I have only a value in one KF.

Is this possible ?

Do you have tricks to initialize a KF without have to actually load data in it ?

Here is my calculation:

IF( "KAMLIFTCENTSOFF@PERPRODPOSPROMO" - "KAMLIFTCENTSOFFW1@PERPRODPOSPROMO1" > 0 , "KAMLIFTCENTSOFF@PERPRODPOSPROMO" , "KAMLIFTCENTSOFFW1@PERPRODPOSPROMO1" )

Here is the Screen of the Planning View (I want the red areas to be calculated):

http://image.prntscr.com/image/2f0ba5164bea4cb29ecf13ac5576c25d.png