Parse Error at char(1): Unknown variable "My variable".... but variable exists?

[KikiMartin]

Hello,

I'm trying to create a formula with a previously calculated variable.  (PeakAccel & AveAccel)

But, when I try to use these variables in a formula downstream....

...though it appears in variable list:

I am perplexed.  Why isn't the variable recognized in the formula tool?

Thank you for the help,

(I'm a novice user, eager to improve).

Kiki

[NicoleJohnson]

I believe it's an issue with the square brackets you have contained in your field name. If you change the field name to AveAccel (g) @1Hz (Watts/10) instead, with parentheses instead of square brackets, it should work.

NJ

[DanS]

Looks like the brackets might be causing a problem in your headers. Try adding another one in the formula. 

Ex.

"...[Watts/100]]]..."

That should work.

[KikiMartin]

THANK YOU! 

The additional square bracket worked!

(But for my understanding, why?  It seems like it would be an unmatched bracket).

[DanS · Accepted solution]

Not 100% without seeing your whole workflow, but it could be that it hadn't picked up the new column at that point in the workflow yet. 

F5'ing your workflow should update the downstream newly created columns. 

Thanks,

Dan