Hey all,
Hopefully a simple question and hopefully I didn't miss an answer somewhere else while searching.
I'm wondering if there is a way to point the formula tool at the field it is changing without actually typing the name in.
Something to the effect of:
IF ISNULL(this)
THEN 0
ELSE this
ENDIF
I only ask because I currently have 220 of these statements to set up after a crosstab and if I could just copy-paste the same thing in it would be much quicker.
Solved! Go to Solution.
Scratch that just used a multi-field to handle it. I would still be curious if there is such a function though.
Perhaps the Multifield Tool with Dynamic or Unknown Fields ticked.
The use the expression,
IF ISNULL([_CurrentField_])
THEN 0
ELSE [_CurrentField_]
ENDIF
I think this should work. Otherwise you could transpose > apply formula to [Value] field > and then crosstab back again.
P
Oh, I didn't even think to use the dynamic fields for it. My autopilot unchecked that.