I have a complicated issue due to how the shareholders want the data displayed and the calculations involved.
What I am trying to do is simply get for Month 1 for the [Projected Carry From Prior Month] to be
Month 0 ([Shipments Calc] + Month 0 [LOD Actual Demand]) - Month 0 [Forecast) resulting in 24,422 ((14,490 + 111,872)-101,940).
I kept the Old Formula for the [Projected Carry From Prior Month] metric in the workbook as it is made up of three calculations. The issue is when i bring in [LOD Actual Demand] I get the error of cannot mix aggregate and non-aggregate. No matter what I try I cant get the error to fix unless I break the [LOD Actual Demand] by taking off the additional SUM in the formula which results in the wrong answer. Any help would be greatly appreciated. Tried multiple
resources before asking here and they could not figure this out
(
#Tableau Desktop & Web Authoring #LOD #Formulas #Tableau
Hi, @Blake Swan
I may still not fully understand what you’re trying to achieve, but is this the kind of calculation you had in mind, as shown in the attachment? Please take a look.
<sample>
