Configurations: Value Providers

Created by GM Support, Modified on Thu, 17 Aug, 2023 at 10:36 AM by GM Support

Under the Value Providers tab, all BC fields (columns) related to the grid, are contained, along with output types (Output Type) and field numbers (Field No.). Field search is also provided.



In the Custom section, there is an ability to create a new value provider (new column) by adding a formula or using a value from an existing BC page:



Example of adding a new column with a formula:


 


Important notes

  • BC values in the formula must be given in double curly braces, e.g. {{Sales}}. 
  • Brackets are allowed for stating mathematical precedence.


Supported operations


+addition
-subtraction
*multiplication
/division



Example of adding a new column using a value from an existing BC page:


 

After you create a calculated value provider, it is added to the BC Fields list (BC Columns) and can be used just like standard BC value providers in Meta UI (for configuration of columns, styling rules, etc.)




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article