2 Replies Latest reply on Nov 21, 2018 11:35 AM by Abraham Hamad

    Table Calculation if > 0

    Abraham Hamad

      Hi,

       

      I'm trying to do a table calculation if the value being calculated is >0. Otherwise, the value should be zero. I'm trying to calculate remaining sales to the forecast. The calculation is forecast - sales. But if the sales exceed the forecast, I'd I want it to be zero.

       

      I've attached a simple sample workbook. I tried using the following calculation on the shelf but it didn't work:

      IF (SUM([Forecast (Sample Data)].[Forecast])-SUM([Sales]))>0 THEN SUM([Forecast (Sample Data)].[Forecast])-SUM([Sales])

       

      Thank you,

      Abraham