how to create new column in sap lumira 1.31.7 table to calculate variance between 2 columns?

[Former Member]

we have (Value Type) as actual & plan data

i want to create new column in a table to show the difference between actual and plan data as a variance like these..

[TammyPowlas · Accepted solution]

Hi - have you tried creating a calculation as shown below?

Except yours would be Plan-Actual

[Former Member · Accepted solution]

thanks for your help , i know that but this is not solution, Value type has two record 10 as plan & 20 as actual , plan & actual not measure it's a dimension

total revenue,total costs,total expenses & net value ..., is a dimension..

[Former Member]

Value type has two records 10 as plan & 20 as actual , plan & actual not measure it's a dimension

total revenue,total costs,total expenses & net value is a measure..

[TammyPowlas]

Hi - you can convert plan and actual to measures and then create the calculation - good luck

[Former Member]

how to divide (value type) to plan individually and actual individually

what is the formula for that