4 Replies Latest reply: Sep 14, 2017 7:12 AM by Suraj Kumar RSS

    expression help

    Suraj Kumar

      Hi Experts,

       

      I have data for 4 months(Jan to Apr)

      I want to create an expression that show if Apr-2012 percentage is greater than Jan-2012. If there is no data available in Jan then take feb and so on.

       

      eg- For Product Sub-Category- 'Office Furnishings' there is no Jan data, so pick the Feb. Similarly 'Bookcases' don't have Apr data, so pick March data.


      image.png

       

      Please help!