Overview
The data conversion facility within Yellowfin allows you to transform data after it has come back from the database. For example you may wish to convert a currency value which is stored in the database from a full currency value to a ('000) where the value is divided by 1000. This transformation can be achieved using the data conversion.
- Drag the field that you wish to apply the conversion to into the report builder field section.
- As with the advanced function select the field and click the advanced function button to open the advanced function popup.
- Choose the 'Data Conversion' tab. This will provide you with the interface to use to select the conversion you wish to apply.
- Choose the aggregation appropriate for you conversion
- Click 'add' to apply a conversion - this will present you with a list of possible conversions for the data type you have selected. Yellowfin comes with a java date converter and a Numeric divide convertor (This lets you divide a value by 1000's etc).
- Follow the on screen instructions for the convertor and click save.
- Note that you can add multiple convertors to a data type if required by clicking the add link and creating a new type.
