"This" or "Me" function in formula tool.

[NRoland]

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. 

[NRoland · Accepted solution]

Scratch that just used a multi-field to handle it. I would still be curious if there is such a function though. 

[PhilipMannering]

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 

[NRoland]

Oh, I didn't even think to use the dynamic fields for it. My autopilot unchecked that.