In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Expressing calculation result as a percentage

Nickolay
6 - Meteoroid

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?

4 REPLIES 4
Sebastiaandb
12 - Quasar

Hi @Nickolay ,

 

Way i normally get that % value is just making a string field out of it like:

 

Sebastiaandb_0-1667313813595.png

 

:-)

 

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

DataNath
17 - Castor
17 - Castor

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:

 

DataNath_0-1667313937495.png

gautiergodard
13 - Pulsar

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.

gautiergodard_1-1667314138869.png

 

 

Nickolay
6 - Meteoroid

Thanks a lot all! It works for me ðŸ˜€

Labels
Top Solution Authors