Condition output whole number

Question

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 Answer

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 Answer

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