Defining the Format of the Currency for QBDE
You can use the QBDE to get the count of records. As a result, you can format the DEs that are query-based to hide the currency symbol. That is, you have the option to hide the currency symbol, at the data element (DE) level. As a result, when viewing the value in a query-based DE, the system displays the correct format so that the number makes meaningful sense.
Example
A Budget Change BP may have the 'Count of Change orders' QBDE (defined as a DE of SYS Numeric Query type) associated with the BP. On the same BP, there may be another QBDE 'Sum of All Change Orders' which needs the formatting of a Currency DE. You can choose whether or not to display the currency symbol for these DEs at runtime.
In the Admin mode, you define the Data Element (DE) that is query-based, add it to the BP form, and set up the query. In the User mode, you can see the results in the run-time (for example, displaying or not displaying the currency symbol).
The Data Element properties tab of SYS Numeric Query Based Data definition contains a check box option for hiding the currency symbol in Cost type BP. By default, this option will be deselected.
Note: When the same DE is placed in non-Cost BPs, this option will be ignored because these BPs do not display currency symbol for data definition with Input type of Currency Amount at runtime.
Go to: Company Workspace (Admin mode) > Data Structure Setup > Data Elements to find the DEs that are query-based.
Click Find and enter "qbde" in the Search for field box to find the DEs.
When you open a query-based DE (Modify Data Element window), you have the option to select, or deselect, the Hide Currency Symbol in Cost type Business Process option.
Depending on your selection, the system displays, or hides, the currency symbol for the query-based DE.
Configuration Package
The format set in the DE must be included in the bundle.
See Also
Using Formulas or Conditions in Queries
Assignee Filter Query Condition
Query Based Data Element (QBDE)
Last Published Tuesday, December 12, 2023