14 Replies Latest reply: Dec 29, 2014 7:05 AM by Prashant Sangle RSS

    Condition for missing value

    Андрей Шепель

      Good day!

      My task is to make conditions for missing value.


      I have sales points and make pivot table with such dimensions:

      1. Sales Point

      2. Date.


      There are some dates with sales "-". It's missing value. Is there any way to set '!' for missing value in expression?


      Such as.. if(sum(sales)  <condition> for missing value,'!','V')