3 Replies Latest reply on Sep 19, 2018 6:10 AM by Zhouyi Zhang

    If function does not calculate right

    Rene Kortekaas

      Hi, I'm new here and I struggle with the following formula. For some reason it does not work right. If there is no forecast amount

       

      When using following formula I get the correct numbers but no numbers in the Kolom June which is correct

      IF  [Description (DimForecastScenario)] = 'Revised Forecast 1 Realistisch'  then [ForecastAmount]

      however if there is no forecast amount for the month june the actuals has to been shown also under RF1. When using Formula

      IF  [Description (DimForecastScenario)] = 'Revised Forecast 1 Realistisch'  then [ForecastAmount] Else Actuals END

       

      then there is a double count in the RF1 amount ( 1115+884). How to solve this problem?