Forum Discussion
Solved
Creating a Measure by using a fixed value
Hi, I need to create a simple measure but cannot seem to make it work. I need to divide 2 columns and then multiply the answer by 100. So it looks something like this: CTR = (Clicks / Impress...
Finally, I figured out your issue.
If you want to change the decimal number to percentage, you can't multiple 100 in the coding. That will make the result be larger.
You need to choose the measure and change to percentage format.
ryan_mayu This is great! Thanks 🙂
This solves this issue. But I have similar situations where i need to multiply by a fixed number. I find it hard to believe how it is not possible to multiply by a fixed number. Maybe, I can just add a column with this fixed value and multiply my answer to it. I guess that might work. If you know of any easier solution please let me know 🙂