cancel
Showing results for 
Search instead for 
Did you mean: 

Calculate a difference column showing difference from Input Measure Control

0 Kudos

Hi,

In our company, we are in the progress of developing a planning story & model for next year

I have added Actual 2021, 2022 and 2023, Budget 2023 and Planning 2024 to the table as columns - see screenshot below. We are using the new model for the story. In the planning story, the numbers are created using currency conversion measures with input measure control added. So for all numbers in the table, we can switch between 4 different reporting currencies we have + local currency for the specific companies.

When I have these numbers in the table, how can I create a dynamic difference column where the end-users can compare the different periods specified in the table below against Planning 2024? Is this possible, with input measure control used in the table?

Model measures:

Value Local Currency

Conversion Measures:

Value_Currency1

Value_Currency2

Value_Currency3

Value_Currency4

Value_LocalCurrency

Dimensions used:

G/L accounts

Cost Center list

Date

Version

Help is much appreciated 🙂

AlexGourdet
Product and Topic Expert
Product and Topic Expert
0 Kudos

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

Accepted Solutions (0)

Answers (0)