stored calculation question
hi
we are using stored calc to apply tax rate on pre tax income and eventually calculating net income. Tax rate is pretty static throughout the year but it may change in middle of the year. we've g...
Forum Discussion
Yes, your data will not change in January to March if you follow this. You just need to change your parameter "taxRate" to pull the data from each month, enter the new 25% tax rate in April and all data will remain as needed (as the formula will pull the 20% for calculating January to March, still).
The OneStream Remote Consulting team may be able to help with this too if needed (billable service).
ok. i am changing taxrate parameter for each month. and the tax calculation at entity level in local currency is as expected. 20% till march and 25% YTD in April. but converted USD is slightly off..25.xx%. we've 50+ entities. and where entity currency is USD, USD Tax is 25%. it is just for entities where entity currency is non usd.
I notice when adding in the V#YTD:T#POVPrior1 you are reading from F#Top:U4#Top, which differs from where you are writing your calculated result. Is it possible F#Top:U4#Top is including additional non-calculated intersection?
I effectively use the same method you showed to apply rates that can vary over time, and it works very well. But, I do make sure I read the V#YTD:T#POVPrior1 from exactly the same intersection I wrote to, so that I have no chance of including any additional 'surprise' data.
