Resolved! Short cuts in the business rules editor?
Hi all Are there any key short cuts in the business rules editor? Cheers
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...
Calc values in forecast scenario by referencing S#Actual, V#Trailing12MonthAvg
I have a forecast scenario S#AugFcst_7_5 with the following properties:WF Time = 2023M7WF start time = 2023M1WF end time = 2024M12# no input periods = 7I have a Finance business rule function that is being initiated using a dashboard button in the wo...
Resolved! Can I use api.data.calculate to insert text?
Hi Team,I wanted to insert a text to data cell (for example 'Add comment'). Is it possible to be done by using api.data.calculate?This is how I see this:Dim Comment As String = "Add comment"api.data.calculate("V#Annotation:A#xxx:F#xxx:O#xxx:I#xxx:U1#...
Key Error on an account member formula
I'm trying to figure out where I can access the Key related to this error. I created a series of new accounts and member formulas by extracting an existing set of accounts from our application.I opened the extracted file in Notepad and performed a fi...
Create a Function to read data from excel file in local file system Using BR api
I want to read a list of members from a excel file which is store in OS file system and store that list of member ID in a list to perform further calculation
Resolved! Using a variable in the calculate string formula
Hi,I am in a custom business rule. I have a calculate formula like the following one, which works fine:api.Data.Calculate("A#Sales1 = A#Sales2 + 50”) Now let say I want to declare a variable instead of having the 50 typed in the formula string, and p...
