4 Replies Latest reply on May 27, 2017 9:54 AM by Jim Dehner

    got stuck - Null cells do not work

    Serge Trydid

      Hey guys,

       

      please help - got stuck and seems like i am missing something simple.

      I need to calculate an abs difference between sales in 2017Q1 and 2016Q4. the problem is that certain accounts did not have sales in one of them. the result is that empty sales did not work well. I tried to fix it. As a result - when I place it in table rows - it shows the right things, but when I try to use it in formula, i.e. difference in sales, it does not work

       

      Appreciate your help!!!!