cancel
Showing results for 
Search instead for 
Did you mean: 

Calculations in MDM

Former Member
0 Kudos

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

Nadine

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Procedure:

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,

Regards,

Vinay Yadav

former_member201266
Contributor
0 Kudos

Hi,

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

http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0615a82b40a2ee10000000a11466f/frameset.htm

Regards,

Cherry.

Former Member
0 Kudos

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

Thanks-

Ravi