Need help with the following LOD called "LOD Line Weekly Past Due Tons". Its essentially tons that have not shipped from prior months up to the current Month (Month 0). I would expect 11,562 to appear on every Month Number. I can get that with a simple Exclude. however when trying to add to "Actual Demand" of 100,310 I get 111,348 instead of 111,562. See "LOD Actual Demand Week" for the formula where I expected to see 111,562. Any Ideas how to get this to be able to add across correctly. See Test Tab 2
Hi, you may use:
SUM({ FIXED [Charter Product Type],
[Customer Name],
[Customer Number],
[Market Segment],
[Product Type],
[Month Number In Relation To Current]:
SUM(
IF [Month Number In Relation To Current] = 0
THEN [Actual Demand]
END
)
})
+
SUM({ SUM([Line Weekly Past Due Tons])
})
If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Tableau Ambassador
