Rules
Discuss Formulas and Business rules for your application
cancel
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
  • 2510 Views
  • 6 replies
  • 3 kudos

Assessed Loss utilised in current year - Tax

Hi, anyone has worked with a similar member script or rule that has a conditions - eg assessed loss utilised in the current year is based on higher of $1 million and 80% of Current Taxable Income account. This is limited to the assessed loss carried ...

Qiniso by New Contributor III
  • 261 Views
  • 3 replies
  • 0 kudos

Resolved! FilterMembers using Cb#Cube

Hi All, Is there a way to the use cb#cube in the data buffer FilterMembers? I'm trying the following, but it does not work. Dim sourceBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("RemoveZeros(FilterMembers(Cb#Cube:V#Periodic, [A#123.Base...

GParreiras by New Contributor III
  • 635 Views
  • 4 replies
  • 0 kudos

Consolidation process

Hi everyone, I'm having issues when launching the consolidation process after loading data on the cube. Below you can see the calculation that is triggered when the consolidation process is launched: api.Data.ClearCalculatedData(True, False, False,"A...

fc by New Contributor III
  • 560 Views
  • 6 replies
  • 0 kudos

Dynamic Calc Rule

Hi All In the below example value is displayed on every single combination of UDs. This should only be calculated and written to each UD7 separately but calculated on Tops and displayed only on “NotDefined” for all other UDs. For any other POV combin...

OS_Love by New Contributor III
  • 208 Views
  • 1 replies
  • 0 kudos