Percentage points change
We are looking at a solution to create point percentage change column.
In the given example we would like to create a measure that can be calculated on percentages, but will be presented as a number.
For example, in the first line here, we are looking at 5.2% - 4.48%, while a required result would be 0.72 (without the % sign).
Even if the define the measure as a number in formulate, it would still show % in discovery.
you can achieve this easily using the Quick Calcs in Discover.
- Click on the "+" icon in the vertical column of icons to the left of the Grid canvas.
- Click on the first column header (Margin), click on th second column header (Net Margin), then rightclick one of the selected columns, choose Quick Calc --> Create MEasure --> Constructed Functions --> Subtraction.
You can right click on the created Measure to change its name, formatting etc.
Hope that helps.