Is it possible to express result of a calculation as a percentage value? For example, if division is used: 2:5=0.5 to show it as 50%. I am aware that % sign can be added via concatenate. But is there an easier way of doing it?
Hi @Nickolay ,
Way i normally get that % value is just making a string field out of it like:
:-)
Edit after reply of @DataNath ... i'm so lazy haha ;-) added the *100, thanks for pointing it out mate!
Here's the formula: tostring(([Field1]/[Field2])*100)+"%"
Greetings,
Seb
Unfortunately not whilst keeping a numeric data type or anything. The best way to go about this is do what @Sebastiaandb has done and calculate the value whilst turning it into a string before adding %. Just be careful - you need to multiply that result by 100 to get it as a true percentage:
hey @Nickolay
I agree with @Sebastiaandb on this one.
Another quick way to do it if you are you going to be outputting your results using a table tool from the reporting pallet is by using the prefix functionality shown below.
Thanks a lot all! It works for me 😀
