Get MTD values for nonfinancial accounts
I am trying to get the MTD values for different nonfinancial account types in my cube view. However, I am not sure which is the best way to do it so it is flexible, easy to maintain, and not overly complicated.
Here is my only requirement:
- Account type HAS TO BE nonfinancial
Context:
I have a form that have the following columns
Accounts | Manual input YTD | Import YTD | Total YTD | Total MTD
Because we changed the account types to “Nonfinancial” they behave as Balance accounts, so when we manually input data the total MTD show up as the same YTD value.
My solution was to create the following QV formula
GetDataCell(E#|!parameter!|:O#Top:U3#Top_Data_Source - E#|!parameter!|:O#Top:U3#Top_Data_Source:T#PovPrior1)
This solution is working and is giving me the answer I expect, however it won’t let me drill down…
Does anyone know if there is a better way to do it? or if this will be one of the best solutions?