1 2 Previous Next 15 Replies Latest reply: Aug 23, 2013 10:08 AM by user7735252 RSS

    #Error shows from [A]-[B] in the report

    user7735252

      Hi all,

       

      I have this issue that shows "#error" from using the formula [A]-[B] in the report.

       

      In Column A, I have:

      - Current Month

      - Current Year

      - Actual

      - value = 0

       

      In Column B, I have:
      - M-T-D

      - Current Year

      - Budget

      - value = 0

       

      In Column C, it contains the formula "[A]-[B]".

       

      I was wondering if this could be an issue when you have 0 - 0, then you should get "#error" or is there something that I'm missing?

       

      Thanks

        1 2 Previous Next