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 to say, you have the option to hide the currency symbol, at the data element level. As a result, when viewing the value in a query-based DE, Unifier 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 checkbox option for hiding currency symbol in Cost type BP. By default, this option will be unchecked.
Note: When the same DE is placed in non-Cost BPs, this option will be ignored since 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, Unifier displays, or hides, the currency symbol for the query-based DE.
Configuration Package
The format set in the Data element must be included in the bundle.