This bug was reported back in February here: Calculated field working on preview, but not in analysis
This previous thread has been archived so I cannot post there, but I am still experiencing this bug i.e. adding a calculated field to the dataset works fine in the preview, but just comes through as “null” in the analysis, whereas adding the EXACT SAME calculated field to the analysis works just fine.
Just wasted an hour trying to get this working but just looks like a bug. Any news on a fix for this?