![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/03\/8_22-2.png\")
<\/a><\/p>\nTo create a numeric parameter, right-click anywhere in the parameter list. A pop-up menu appears allowing you to add a parameter:<\/p>\n
By clicking on the “New Parameter …” menu item a wizard to create a numeric parameter appears:<\/p>\n In form that opened you should fill in the following fields:<\/p>\n This parameter can be used in calculated measures, members and sets:<\/p>\n Let us look at the following example. For instance, we need to analyze how the margin for the \u201cBikes\u201d subcategory changes provided that the prime cost of goods increases by 10%.<\/p>\n In order to do this, create a parameter \u201cProduct Cost\u201d:<\/p>\n After that, we need to create a measure for \u201cPlan Gross Profit\u201d, which will calculate predictable margins using parameter \u201cProduct Cost\u201d:<\/p>\n Now let us create a report with the \u201cBikes`\u201d subcategories on rows:<\/p>\n In columns it is December 2017:<\/p>\n Now let us add three measures to our row: \u201cSales Amount\u201d, \u201cGross Profit\u201d, \u201cPlan Gross Profit\u201d. As a result, you will get the following report with parameter \u201cProduct Cost\u201d:<\/p>\n Let us increase \u201cProduct Cost\u201d by 10%:<\/p>\n<\/a><\/p>\n<\/a><\/p>\n\n
<\/a><\/p>\n\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n