Null values on advanced formula in SAC

[mayiya]

Hi. 

I have issues with null values when calculation forecast. For example, I need to calculate forecast for 2024.04= value 2023.03 * (1+ (% participation 2023.04 + % participation 2022.04)/2).. my issue is when there's no value for 2023.04 or 2022.04 (because is null), I need that when is null it is treated like a zero. 

I had try: value 2023.03 * (1+((% participation 2023.04 x (0+1)) + (% participation 2022.04 x (0+1)))/2)

But it still does not work. 

Any suggestions please

[N1kh1l]

@mayiya 

Null check has performance issues but the syntax to check is like below

IF RESULTLOOKUP() != NULL 

So you can check for your % participation 2023.04 and % participation 2022.04 for not being null and in else part of this check you can replace the percentages by 0.

Nikhil