<aside> 💡

A Calculated field is a formula that performs some action on one or more other fields in a report’s data source.

</aside>

Welcome to the MoveHQ help center! We're here to answer your questions. Can't find what you're looking for? Send our support team an email at [email protected]

Adding a Calculated Field 📖

  1. Open any report in the Designer and click the Field List buttion

    Untitled

  2. Click the Add Calculated Field button

    Untitled

  3. Set the Display Name, Field Type, Data Source, Data Member and click the three dots in the Expression row

    Untitled

  4. Set the data field to operate on

    <aside> 💡 Note: do not select the field in which the expression is being edited

    </aside>

    Untitled

  5. The Report Designer includes many different functions

    Untitled

  6. For simple math select Operators, double click and option, set a number and click OK

    <aside> 💡 Note: in this example the Calculated Field will multiply the Quantity value on each row by 10

    </aside>

    Untitled

  7. Add the field and a label to the Report

    Untitled

  8. The Calculated Field displays and multiplies the Quantity value of each row by 10

    Untitled