Skip to Content
avatar image
Former Member

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

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..

capture.png (12.3 kB)
edit.png (61.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 03 at 11:12 AM

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

    Except yours would be Plan-Actual

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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..

      value-type.png (3.1 kB)
  • avatar image
    Former Member
    Jan 03 at 12:12 PM

    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..

    Add comment
    10|10000 characters needed characters exceeded