I have a table calculation calculating the weekly difference between current commitments in 2 academic years, it looks like this:
SUM([Current Commitment (Weekly)]) - LOOKUP(ZN(SUM([Current Commitment (Weekly)])), -1)
The issue when current commitment is 0, this happens twice in Week 20 when there is simply no data in 2017-2018 to compare, and the upcoming week since the data is not available yet.
I could just hide the outlier week, but I would rather change the calculation so these long bar graphs don't show. How can I do that?
Hi Diogo,
WOuld the following work:
If SUM([Current Commitment (Weekly)])>0 then
SUM([Current Commitment (Weekly)]) - LOOKUP(ZN(SUM([Current Commitment (Weekly)])), -1)
end
Joe