cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Currency Conversion - Input Control

SAC_Newbie
Explorer
0 Kudos
215

Dear all,

I am creating a data model and story in SAC where I am once again seeing some problems.

I have created a model with two measures Amount in LC & Amount in GC with three version Actual, Budget & Forecast.

Now I have created a story with a lot of different calculated measures to show in a few graphs (Actuals vs Forecast CY, Actuals vs Budget, ...). Right now these calculated measures / restricted measures are created on top of the Amount in LC.

I am struggling to do the currency conversion as I am not familiar with the best practice.

Initially I thought that I will create a measure input control which allows to toggle between Amount in LC and Amount in GC. This should have been used to create calculated measures on top of this new measure input control. But when creating this new measure input control I saw the following error

SAC_Newbie_0-1728413324055.png

Do you know how I can avoid this? Is there any better way for doing the currency conversion accross multiple calculated measures in the story?

Best and thanks

View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

I assume the warning is due missing filter on version. Please check if for each measure used in input control there is version specified or the version should be specified either in widget or page/story. 

SAC_Newbie
Explorer
0 Kudos
Dear William, thank you for your reply. I cannot specify one specfic version filter in the widget as I am using measures with two different versions (comparing ACT vs BUD). Now I have created a new calculated measure in the model which is using a currency variable. this measure is the base for my calculated measures in the story. once i switch the currency all currencies in the story get changed. is this the best approach?
William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos
Yes, currency variable definitely the good option if it fits your use case