Formula Preview Correct but actual output is incorrect

[JJAlbert]

Hello,

I've run into a strange one when creating a formula. The preview shows the correct answer, however the output once I run the workflow is different!

See screenshots:

I duplicated it to see if it was a glitch, but it also came out the same.

Any idea why this is?

TIA!

[atcodedog05]

Hi @JJAlbert 

Can you provide some sample input, workflow and expected output it will help us get a better understanding of the usecase.

[JJAlbert]

I figured it out 😅

Turns out my previous calculation for [DF] was set to be an Int32 when it should have been a Double. I assume Formula preview reads everything as a Double for its display and then in the output converts the data types!

[atcodedog05]

Glad to hear you solved it @JJAlbert 🙂

Cheers and have a nice day!