Is this a bug?

abe_ibanez

I have a formula tool that is supposed to insert a null value if a condition is met.

if [period_paid_2] = [next_month]
then null() else [period_paid] endif

but even when the condition is met, it still leaves period_paid unchanged.

The weird thing is that the data preview correctly shows a null value, but this is not actually flowing through to the data.

Currently using Version: 2025.2.1.117 Patch: 3

Screenshot 2026-04-22 124044.png

formula_bug.yxmd

OTrieger

@abe_ibanez
I cannot open the Alteryx file as do not have Designer on my private laptop. What is the data type of next_month and period_paid_2, if both set as date then should be fine but if both string there might be spaces so try: IF [period_paid_2] != [next_month] THEN [period_paid] ELSE Null() ENDIF.