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

Forum Posts

[howto] Use "Insert Code" when posting on Forum boards

Hey guys! Just a reminder: if you're going to post code in this forum, please make it easier to read by using the "Insert/Edit Code Sample" button on the expanded formatting toolbar. Here's a short video showing how it works. If you need to edit code...

tmp.png 1c_code.gif
JackLacava by Honored Contributor
  • 6 replies
  • 3 kudos

Resolved! Extensibility Rules error

I have the existing BR rule to export the region hierarchy which is working for last one year without any issues and I am trying to reuse the BR rule for country hierarchy export purpose. I copied & pasted the BR rules, and I am getting the error bel...

vpidala by New Contributor II
  • 10 replies
  • 0 kudos

C#Aggregated and Custom Translation Rule

I am looking to create a FX Rate finance rule or calculate to go get the planning scenario's last actual month's closing rate from the ClosingRate FX table. I am using the consolidation member C#Aggregated in the planning scenarios. I know that C#Agg...

ajslack by New Contributor II
  • 1 replies
  • 0 kudos

Resolved! Running DM package from the BR and completing the workflow step

I would like to give my users the ability to launch the DM sequence from the workflow step. I have the dashboard with the button that passes the parameters to the DM package and launches the package. The last step in the DM sequence runs the Extensib...


XFBR in Literal Parameter is not returning value as expected

Hello Everyone, I need a Literal parameter which will dynamically calculate something like the prior forecast based on another parameter so i ended up writing an XFBR for that Literal parameter, something like below XFBR(HelperRule,GetPriorForecast)....

VENKAB05 by New Contributor III
  • 3 replies
  • 0 kudos

Resolved! Business rule to choose scenario based on Text3

Hi, I am trying to create an account member formula where I have Account A divided by Account B, but the scenario in the denominator should be decided based on Text3 in the POV Scenario. E.g. A#10000:S#Actual / A#20000:"& SourceScenario &" SourceScen...

Filip by New Contributor II
  • 2 replies
  • 0 kudos