I need some help building out the following two calculations on stored member formulas. They would need to run at every UD.1) = MIN((A#Account1 - 4.5%), (A#Account2 - 6%), (A#Account3 - 8%))2) = MAX((A#Account1 - Account2 - Account3 - Account4),0)Tha...
Hi All,I'm looking to filter a dynamic calculation by the base of my income statement and balance sheet accounts. The result of this dynamic calc will be leveraged within a confirmation rule. Do you have any suggestion on how to effectively filter th...
Hello Everyone, Looking for a quick help Please.Here I am trying to write a Dynamic Calculation code which will follow the exact logic of PVA translation however will use rates from previous year.So kind of a Constant currency solution.However when I...
Hi Everyone,In building out our financial reporting, I was seeking to get some opinions on best practice related to adjustments for financial statements when scaled and rounded to millions. We are coming from doing our consolidations and external rep...
Hi allHow can I run a calculation for a subset of dimension members. Something like all base members of member Top, but not the none member, or just the members with text1 attribute = "Calculate", or just a comma separated list of members.Do I need a...
