community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Condition output whole number

Meteoroid
Hello, I am trying to create a workflow that will output whole trade prices (ie 126.35312) and if fractional price is present, will convert fraction price to whole price (ie 126-11.3). 126-11.3 (fractional number) (11.3/32 = .35312) 126.35312 (whole price) Thank you!
Aurora

Hi @beattyb 

 

The formula that @EstherB47 provided yesterday when you asked this same question will work

 

IF Contains([number],"-") THEN tonumber(left([Number],findstring([number],"-")))+tonumber(right([Number],length([number])-FindString([Number], "-")-1))/32
ELSE [Number]
ENDIF

 

Replace [Number] with the name of the field where your values are

 

Dan

Highlighted
Pulsar

Thanks, @danilang 

@beattyb , if this solution works for you, please mark it as such. That helps the rest of the community find answers to their questions too.

 

Cheers,

Esther

Labels