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 to display the currency symbol for these DEs at runtime.

In Admin mode, you define the Data Element (DE) that is query-based, add it to the BP form, and set up the query. In 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 the currency symbol in Cost type BP. By default, this option will be deselected.

Notes:

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.
When using QBDE, be aware that query elements are rounded off to use two decimal places, even if the Base Currency and various defined currency fields are different.

To find the DEs that are query-based:

Go to the Company Workspace tab and switch to Admin mode.
In the left Navigator, select Data Structure Setup , and then select Data Elements.
From the toolbar, 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