A data mismatch between the data type of a data source and the Business Rule's output type is highlighted with a red icon. To know what the data type of the data source is, place the cursor over the icon.
To find the Business Output Type, expand the Details section at the top of the new business calculation screen. The Output Type field towards the end of the section. When using "Money" as the business rule's output type, the most likely reason for the mismatch is that the output type of the logic step is "Number".
In most cases, the way to resolve the data type mismatch is to remove the created function in this case the Housing Allowance Table Lookup and replace it with a Maths function.
When Math is selected a Data Source, a pop-up window is displayed giving the possibility of performing one out of four actions: Create New, Copy Existing, Select Existing and Run Existing. Press [Create New] which allows you to perform calculations between different operators but is also used to set a currency to a number field types.
After clicking [Create New], the Maths pop up window appears. Enter a name for the function.
Change the Output Type to Money and then select Table Lookup to create the Maths Operation.
Press [Select Existing].
And select the Table Lookup from the drop down list before pressing [Select Existing].
After pressing [Select Existing], the name of the Table Lookup appears in the Maths Operation section. Lastly, select a currency and then press [Save]. In this example, a database field was selected but it is possible to use any currency such as from a data table using the Table Lookup option or a Fixed Value.
A money icon appears besides the field and the data mismatch is resolved.
