cancel
Showing results for 
Search instead for 
Did you mean: 

User input for key figure

Former Member
0 Kudos
45

Hi,

I have 'List price' as my key figure. Now I want to take input from user as percentage and display 'list price * percentage' in my report.

Please tell me how can I do this.

Thanks

Shilpa Bansal

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Shilpa,

Please try this:

Go to Query designer

Select new formula

Right mouse click on ‘Formula Variable in Operands section

Select New Formula Variable

Type in Formula Name and Description

Push ‘Next’ Button

DimensionID should be ‘Number’

Push ‘Next’ Button

IF a Default Value is desired, pleas type in now

Push ‘Next’ and then ‘Finish’ Button

DoubleClick on newly created variable and multiply it

With existing keyfigure and divide it by 100.

Hope I didn't forget something

Regards

Joe

Former Member
0 Kudos

Hi Joe,

Thanks a lot for your help. It was very helpful.

I really appreciate it.

Thanks

Shilpa

Answers (0)