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

Obtain entities in a BR for comparison

Hi Everyone. What I want to do is to obtain the child entities of an element, to save them in a variable and compare them with the entities that are traversed in a data management, I would like to know how I can do this in addition to how I can get i...

Marco by Contributor
  • 1 replies
  • 0 kudos

Data access on member formula

Hi all, I have a member formula with simple calculation (e.g., Account A / Account B), and there is a data access security set up upon account A. I am wondering if a user without account A access, can the user be able to see the calculated result? My...

Jacky_C by New Contributor III
  • 1 replies
  • 0 kudos

Value was either too large or too small for a Decimal.

Dear Team, while opening the cube view, I am experiencing issue " Value was either too large or too small for a Decimal." I can see that in BR for EndBal, one of the divided formula causing the issue I am thinking. I am trying to add the divide funct...

vpidala by New Contributor II
  • 5 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