Forum Discussion
Scenario modelling tool
create a numeric range .you can set the min , max and the increment. ( 1, or 0.1 ..etc.. )
this will create a table ( in the image above called Paramter ) with one field.
then create a measure =
selectedvalue( Paramter[field_name]) , 1 )
then in your measure that calculates the sales price, you can multiply by the above measure,
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
selectedvalue( Paramter[field_name]) , 1 )
what should be entered in field name? this has not been defined in the process??
In this scenario, field name is just a generic name because we do not know exactly what it is named in your parameter. If you open the table that is automatically created when you setup the parameter, you will see a name for the column that stores the number values. This is what is meant by [Field_Name].