Calculate Keyfigure difference

[Former Member]

Dear SDN,

I have two keyfigures A and B in Cube.

I want C = A - B in the Cube.

Could anyone guide me how to calculate C in the Transformation.

Please give me the routine to calculate C -= difference of A and B.

Formula works or routine is required.

Regards,

Rahul

[pruthvi_r · Accepted solution]

Hi,

I think formula will do the job.

In transformation map A and B from source to one destination C.

Then write the formula as <b>A - B</b>.

Hope this helps.

regards,

Pruthvi R

[Former Member]

Hi Rahul,

Just goto your Infoobject in Transformation.Right click.goto rule details-->Select rule type as Formula.Then Editor will be opened.There select A from the list displayed there then Choose the operator as '-' then choose the operand B.Save it and Click on transfer values.

Hope this helps

Regards

Karthik