Forum Discussion

johnal67's avatar
johnal67
Contributor
2 years ago

Account with combined calculated data and input data?

I want to have an account that has a calculated value (rounding it to thousands), and then allow a Forms input adjustment to it for footing reasons.  The calculated value would have a UD4 of "Calc", ...
Finance
  • JackLacava's avatar
    JackLacava
    2 years ago

    By "calculated" you mean "Dynamic Calc"?

    The way OneStream works, it will execute the first dynamic rule it finds in the sequence (Account -> Flow -> UD1-8), and stop dealing with the cell altogether.

    So make sure you don't put the formula on the Account member, leaving it as a stored member, but on the UD. If you set a dynamic rule on UD4 member "Calc", the UD4 member "Footing" should be unaffected and you should be able to store anything you want there.

JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

By "calculated" you mean "Dynamic Calc"?

The way OneStream works, it will execute the first dynamic rule it finds in the sequence (Account -> Flow -> UD1-8), and stop dealing with the cell altogether.

So make sure you don't put the formula on the Account member, leaving it as a stored member, but on the UD. If you set a dynamic rule on UD4 member "Calc", the UD4 member "Footing" should be unaffected and you should be able to store anything you want there.