Rules
Discuss Formulas and Business rules for your application

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

Data Buffer FilterMembers() with Empty Cells

Does the api.Data.GetDataBufferUsingFormula("FilterMembers(...)") only get cells that have values? Is there a way to create a data buffer with empty cells? Use case: We need to to cycle through an account hierarchy and populate each base account with...

Resolved! Create Excel spreadsheet from Business Rules

Does anyone know if you can create an Excel spreadsheet from Business Rules? I do not mean a csv file - I need to create multiple sheets. The OpenXMLBuilder object doesn't seem to have anything with writing files. I don't want to use a third-party ob...

MarcusH by Contributor III
  • 7354 Views
  • 25 replies
  • 0 kudos

Resolved! Filter Result DataBuffer based on value in secondary Source Buffer

Hello Experts, I have a requirement of calculating Cash_ADJ based a sum value of 2 different buffers. If the sum value is Positive I have to post a cash_adj with value from bufSrc2. Is it possible to filter Buffer 1 and write corresponding buffer 2 v...

mpavan by New Contributor II
  • 1075 Views
  • 3 replies
  • 0 kudos