Tool #2: Parse Error at char(0): Unknown variable "E" (expression #1)

[BRRLL99]

Hi 

I have connected 6 different List box tools and updated the formula with in Action Tool

When I placed the Macro in the Data

I'm receiving this error

Tool #2: Parse Error at char(0): Unknown variable "E" (expression #1)

can someone help me to decode the error

[FinnCharlton]

Hi @BRRLL99 , is Tool #2 the formula tool you are changing? It looks to me like there is something going wrong with your Action tool configuration, leading to the formula being updated to an invalid one.

Some screenshots of your action tool configuration and your formula tool would be useful.

[BRRLL99]

this is the formula I have written in Action tool

[FinnCharlton · Accepted solution]

@BRRLL99 for this issue, the best way might be to get rid of the action tool altogether. You can link the list boxes directly to the "Q" anchor of the formula tool (see below). Then, replace the formula with the one currently in your action tool.

[BRRLL99]

Please share the workflow

[BRRLL99]

could please let me know the reason 

Why action tool was removed?

[FinnCharlton]

@BRRLL99 , you had already written a formula that dynamically updates when the list box values change. The formula tool can deal with this directly, without an action tool inbetween.