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

    preeti.prajapati

      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.

       

      Thanks.