https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-leaving-field-blank-for-random-records/m-p/1296993#M323799 <P>Following up - The records that I was seeing this happen to had NULLS in the fields used to calculate book value. I added data cleanse to replace nulls with 0s and it works again.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 19 Jul 2024 19:11:08 GMT CDIns 2024-07-19T19:11:08Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-leaving-field-blank-for-random-records/m-p/1296992#M323798 <P>Please see attached. I've ran this workflow about a week ago and this did not happen. Nothing has changed to my workflow. I just re-ran it and the formula to calculate book value is leaving some records blank despite having values that would calculate a book value. Any ideas? Is this a bug?&nbsp;</P><P>&nbsp;</P><P>Thank you!</P> Fri, 19 Jul 2024 19:02:21 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-leaving-field-blank-for-random-records/m-p/1296992#M323798 CDIns 2024-07-19T19:02:21Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-leaving-field-blank-for-random-records/m-p/1296993#M323799 <P>Following up - The records that I was seeing this happen to had NULLS in the fields used to calculate book value. I added data cleanse to replace nulls with 0s and it works again.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 19 Jul 2024 19:11:08 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formula-leaving-field-blank-for-random-records/m-p/1296993#M323799 CDIns 2024-07-19T19:11:08Z