Start Free Trial

Alteryx Designer Desktop Discussions

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

Two Decimal Places within Formula

BrandonS4
8 - Asteroid

How do I take this formula I am using in the Multi-Field Formula tool and make it two decimal places:

 

tostring(Round((([_CurrentField_])/([Open Amount USD]))*100,2)) + "%"

3 REPLIES 3
Kenda
16 - Nebula
16 - Nebula

Hi @BrandonS4 

 

Try changing your 2 in your formula to .01

 

Hope this helps!

JosephSerpis
17 - Castor
17 - Castor

Replace the 2 with 0.01

BrandonS4
8 - Asteroid

Simple enough!  Thank you both!

Labels
Top Solution Authors