This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
All referenced fields are set to Double, output is set to Double
and I am getting this type of result - it works yet it doesn't work -
As you can see on the top rows it is outputting the correct column in the # Null column but down at the bottom it is saying that there is a null value in column 3 when there is a number there. Can anybody tell me what I am doing wrong here?
You can also accomplish this through the Transpose tool. It takes a few more steps, but you don't have to hard-code the conditions in so it's much more dynamic. That way if you end up with additional columns or your field names change you don't have to remember to update your formula:
Thank you so much for the use of your eyeballs! Yes I did indeed miss the IsNull function on month 3 and also on month 5 and month 12! I re-read that blasted statement a hundred times yesterday looking for a boneheaded mistake like that and I still missed it. Thank you again.