2 Replies Latest reply on Oct 13, 2018 4:54 AM by Ankit Bansal

    First date above 0 for categories

    Alex Martino

      Hello. I have products and months. How can I find the date where the sum of sales for each day is above 0?

       

      I tried this but it doesn't work {fixed [Category] : if(sum([Sales Volume])>0) then MIN([Date])END}. It returns the first date in the period for all the products even though 1/2 of them are at 0.