use the calc like below
Calculation to use:
(((SUM([Actual Spend])-([Adjustment Parameter]*POWER(10,6)))/7)*12)+[Adjustment Parameter]
plz find the attached workbook
Hope this helps plz mark this answer as correct & helpful to close the thread
FORUM Upload_v10.5.twbx 1.6 MB
Without changing the filters, the Operations Actual Spend is 55.1M not 27.5M. Am I looking at something wrong?
In your data there are 475 rows for [Budget].
Are you looking to do this calc only for [Budget] rows? And where you are using [Actual Spend] in that calc, are you actually looking to get the sum of all [actual spend] for all budget rows?
Or are you looking to do this calc on a row-by-row basis for all 475 rows, and then sum up the results?
Thank you for your response, we are almost there. Included in the data under Cost Category 3, 4, & 5 are sub totals labeled "Result", see below image. I had tried to filter these out using the filters on Tableau but they still appear to be included in the calculation, this is why we are seeing 55M instead of the 27.5M I quoted in my original post. How would I filter out the "Result" line items from Cost Category 3, 4 & 5 ?
Thanks for your reply John, please refer to my response to Naveen. There are sub totals in the data under Cost Category 3, 4, & 5 that should be filtered out, but the filter does not appear to be "working" (i.e. I am likely doing it wrong".
Thanks for your response Joe, I would like to do this not for each line item, but for each major category under Budget. See below, using Naveen's help I have managed to calculate a Run Rate for Operations (its still wrong, do to the filter issue I mentioned in my reply to Naveen). Eventually, I would like to have a Run Rate for all budget categories (i.e. Logistics, CAF etc.)