Discuss Formulas and Business rules for your application
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Member Formula - Min/Max Calculations

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...

camagruder by New Contributor III
  • 5 replies
  • 0 kudos

Filter a Dynamic Calculation

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...

Adjustments for Scaled Financials - Best Practice

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...

JZamorski by New Contributor
  • 5 replies
  • 0 kudos

Resolved! A calc for a subset of dimension members

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...

ChristianW by Valued Contributor
  • 1 replies
  • 0 kudos