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

Forum Posts

Why is 1S not formating pink (which is returned by u8#formula) ?

Hi, I have a u8#memberformula that I am trying to use for the first time - to format the background color of a cell. I know that setting BackgroundColor = pink will cause the cell to turn pink. BackgroundColor = u8#memberfomula my u8#memberformula ha...

Davy by Contributor
  • 4 replies
  • 0 kudos

Resolved! Retrieve member name

Hi all, I'm bit new in developing rules in one stream and I have a simple question. I'm trying to retrieve the accountId member name from a member formula on the account itself. I'm using the below code but it seems api.Pov.Account.Name is not workin...

MStucchi by New Contributor
  • 7 replies
  • 0 kudos

Member Formulas - Syntax Documentation

Hi, I'm trying to set up some new Cash Flow accounts, and as usual I'm looking at the existing CF accounts to see how they've been set up. However, I'm pretty new to OneStream, and I'm struggling to make sense of some of the Syntax. I've had a look i...

Beeswing by New Contributor III
  • 5 replies
  • 0 kudos

Resolved! Extract Formulas for all accounts

Coming from HFM, I'm used to having a single rules file that I can easily search through. In OneStream, the equivalent rules appear to be defined for each individual account as a metadata property. I.e. the Formula. Is there a way to extract all of t...

Beeswing by New Contributor III
  • 3 replies
  • 0 kudos

Resolved! Rounding the result of a formula

I want to round the values for the Revenue account for all UD2 members to whole numbers.Do I have to get the values, round them and write the value, or is there a simpler method?

ChristianW by Valued Contributor
  • 3 replies
  • 1 kudos