Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Afternoon;
I hope this is the right forum, I inherited a dashboard i am trying to understand, its source comes from a spreadsheet.
sum ( {$<[Ops Year] = {$(#=Only(_YYYY))}, [Ops Month] = {"<=$(#=Only(_MM))"},[Division]={'A','B','C','D','E','F','G'}>} [Bookings]/1000000)
/
sum ( {$<[Ops Year] = {$(#=Only(_YYYY))}, [Ops Month] = {"<=$(#=Only(_MM))"},[Division]={'A','B','C','D','E','F','G'}>} [Revenue-Actual]/1000000)
Th calculation works however what i need to change is that instead of the values from one month i need the sum of all months[Ops Months]. This would only be for the denominator.
the number for January I am getting is .19 which is correct as it is only one month, however for February i need the number to roll both January and February numbers in revenue.
Based on the selection of the [Ops month] is should calculate the revenue amount for everything less than or equal to for that selection for the divisions stated, any ideas? I have attached a sample of the source data for the calculation