Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formula: Scaling values in Field Organiser...or separate Formula field? - Visokio Forums
Formula: Scaling values in Field Organiser...or separate Formula field?
  •     dpawley June 8, 2015 11:18AM
    In DataManager, where you have a Field Organiser block, if you have a data field that is a decimal number and you would like to multiple this by 100 or 200, to show in the report, can I just add a scaling formula in the field or do I need to create a whole new formula field to calculate this.

    I want to just convert the number from Hectolitres to Litres.

    Cheers

    Danny
  • 1 Comment
  •     tjbate June 8, 2015 11:37AM
    Danny -

    There is a discussion of this and an Idea here:

    http://forums.visokio.com/discussion/2124/idea-validate-data-scalereplace-an-incoming-fields

    Currently, you need to use a separate formula field to scale values but there is no problem hiding the original un-scaled column/field throughout the file.

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership