Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Condition output whole number

beattyb
6 - 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!
2 REPLIES 2
danilang
19 - Altair
19 - Altair

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

estherb47
15 - Aurora
15 - Aurora

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