Formula Preview Correct but actual output is incorrect

Question

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 · Answer

Glad to hear you solved it @JJAlbert 🙂

Cheers and have a nice day!

JJAlbert · Answer

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 · Answer

Hi @JJAlbert

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