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

Forum Posts

Use computed member across forms/BRs

Hi, I have an account member A#salary which is being computed using BR1 in CV1 and I need to use the computed value in another CV2 using BR2 to compute account member A#61000101. Tried as below: api.Data.calculate("A#61000101:U2#Staff:U4#None:U1#7330...

Rev by New Contributor
  • 3 replies
  • 0 kudos

Average based on dynamic start and end time periods

Hi All, I'm hoping someone can help. I'm trying to create a formula for a planning solution that calculates an average over a dynamic number of time periods but for hundreds of intersections. So essentially I somehow need a data buffer covering multi...

NCI Calculation

Hi All, I'm looking for documentation on best practice to write and NCI calculation? If anyone could point me in the right direction that would be greatly appreciated. Cheers!

Automate consolidation of constant rate scenarios

We would like the ability to auto consolidate 2 other constant ex rate scenarios once we have consolidated the main Actual scenario. We want to retain the ability to consolidate the main Actual scenario in isolation also i.e. we don't want to consol ...

bert by New Contributor
  • 5 replies
  • 0 kudos

Resolved! Destination Data Units

I am passing 2 Entities in the Data unit for Calculation as Entity is different in both the destinations So what i was expecting is that it will run as a for each loop with both the entities so it will pick enitity1 and then run the Calc and then eni...