This content has been marked as final.
Show 2 replies

1. Re: Table Calculation if > 0
Paul Wachtler Nov 21, 2018 11:27 AM (in response to Abraham Hamad)Hi Abraham,
Your formula is really close. This worked when I plugged it into your workbook:
if SUM([Forecast (Sample Data)].[Forecast])  sum([Sales]) > 0 then
SUM([Forecast (Sample Data)].[Forecast])  sum([Sales])
else 0
end
Best,
Paul

2. Re: Table Calculation if > 0
Abraham Hamad Nov 21, 2018 11:35 AM (in response to Paul Wachtler)That did the trick! Thank you so much Paul