5 Replies Latest reply on May 9, 2018 6:16 PM by Shinichiro Murakami

    Calculated Formula

    ljubomir stajic

      Hi All,

       

      I'm having problems with a calculated field. I hope that somebody can help.

       

      Basically, I'm trying to get a calculated field to ignore 1 filter (the month).

       

      In the attached file, the "YE plan" field should show the plan at YE (Accounting Period 12). it's currently showing the plan for the Accounting Period 10.

      Not that the other filter (type) has to work on this field.

       

      I understand that this can be done using a FIXED formula.

       

      Would you please help!

       

       

       

      Thank you,