4 Replies Latest reply: Jan 23, 2018 7:18 AM by Sunny Talwar RSS

    how to get measure value for only null record in dimension

    Prashant Sancheti

      Hi all,

       

      I have a customer as dimention with null values:

      and i have this as measure. Now i want only this measure values where customer is null.

      how we can write this in set analysis

       

      num(Sum({$<GroupDate={'$(=date(yearend([GroupDate],-1), 'MM/DD/YYYY'))'}>}[sales]-[discount])