Skip to Content
author's profile photo Former Member
Former Member

Calculations in MDM

Hello -

I am looking for documentation on how to set up calculations in MDM?

I am having trouble with the syntax of the begining of the calculation.

Thank you for your help


Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 07:40 PM

    Hi Nadine

    example: say you have fields Price, discount and Net Price in repository. Net price is calculated field.

    in the calculation expression write Price/Discount

    Select both the fields from field dropdown and operator "/" from operator dropdown to reduce chances of mistakes.

    Moment you save record in data manager the Net price field will be populated with the calculated value.It will be grayed. also you can perforrm recalculate fields from record context menu in DM.

    Award points if useful



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 18, 2008 at 08:11 PM


    Follow the below link, under expression you will find expression, which you can use as part of your calculations.



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 06:15 AM

    Hi Nadine,

    Calculation Field

    A calculated field is read only field whose value is based on other fields. It cannot be modified in Data Manager, to modify the calculated field one needs to modify the calculation expression.

    Their read-only values are determined by the expression entered for the field in the MDM Console.

    MDM automatically updates calculated field values whenever changes are made to main table fields or qualified table fields via the Data Manager or through import. However, calculations based on lookup field values are not updated automatically after fields on the lookup table are

    modified. In these cases, the calculated field must either be updated manually from the Records pane or else the entire repository must be unloaded and then reloaded with the Update Indices option. To manually update the values of a recordu2019s calculated fields, right-click on the record in the Records pane and choose Recalculate from the context menu. All calculated field values in the selected records will be updated by this operation.


    In MDM Console Calculated field and Calculated expression can be created as follows.

    Create a field in a table and set the Calculated property to Yes.

    Now the calculation property will let you define a Calculation expression.To open the Calculation Expression dialog, you can click the u201Cu2026u201D (Browse) button on the far right of the Calculation cell.

    Enter the calculation expression using the keyboard and the toolbar buttons to enter values, measurements, field names, attribute names, lookup values, attribute text values, operators, and functions.

    Click OK to close the Calculation Expression dialog.

    Press Shift+Enter to save.

    For example: Wecan make use of calculated field for calculating the salary of an Employee where Salary depends on Earnings and Deduction .For the we made an calculation expression on Salary field.

    Where the Earnings are the total of (Basic, HRA, Conveyance allowance and Non Taxable Flexi Plan etc.)

    And Deduction contains (Income Tax, Professional Tax and Transport Deduction etc.) .Here the Salary is calculated on the basis of Earnings and Deduction (Calculation Expression).

    Reward if Helpful,


    Vinay Yadav

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.