1 2 Previous Next 18 Replies Latest reply on Jul 11, 2018 9:50 AM by Deepak Rai

    subtracting based on constant

    Hamza Alsalman

      i have a constant value for one date and I need to drag that value in its own column and populate all empty fields with this value. The value is retrieved by the following formula: SUM(IF YEAR([Prod Dt])=2017 then [Curr Bal Amt] END)

       

      I need this balance except for all dates >=2017 as I need to perform column subtraction. Thanks!

        1 2 Previous Next