Condition output whole number

[beattyb]

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!

[danilang · Accepted solution]

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 · Accepted solution]

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