2 Replies Latest reply on May 19, 2015 7:28 AM by Alex Lin

    How to calculate the distinctive Sales?

    Alex Lin

      Hi

       

      I have two tables in a data source and linked by province and subcategory. I would like to calculate the sales of the distinctive products in relevant provinces. However, my formula returns the same value as sales. Please see my formula below.

      IF [Product Sub-Category (Distinctive)]=NULL

      then 0

      ELSE [Sales]

      END

      I'm not sure where went wrong. Can someone help with this?

       

      Thanks,

      Alex

      1.png

      .