0 Replies Latest reply on Sep 11, 2014 12:42 PM by preeti.prajapati

    How to get value on Last Date when no data is there for that day


      Please find the attached workbook.

      I have to pick sum of sales on last date for all the categories.

      I used this formula and it gives correct values in cross-tab but not in trend chart. 


      LOOKUP(ZN(SUM([Sales])), LAST())


      For the trend chart it picks last available value. E.g.- For Appliance the actual value is 0 but the formula picks last available value 4621.29. I want to modify the formula so that it picks 0.


      Need help on this issue.