This might be a simple one — is it possible to add a percentage format (perhaps using "p") in the numformat transform? I know it’s possible to multiply values by 100 manually, but in a pivot transform with many columns or rows, that can become quite cumbersome.
I assume you want to change values from 0.34 to 34 (%)?
Multiplying by 100 has the same result, with the advantage of having an output that remains a number and not a text string (34%)
That’s correct — using CALCULATE is tedious. For example, this is just a utilization value (a percentage).
I was considering using NUMFORMAT, since only the display format needs to be adjusted.
I have come up with 2 fantastically hacky ways to do it. One involving Reshape, which is rather long winded, and the other uses Replace and a regular expression.
Converting to and from percentages doesn’t really fit with any of the existing transforms. But I’m not sure if it is worth a transform on its own. I will give it some thought.