Cant find column in Totals table - yet column exists and is fine

HI
I have a peculiar one - Will not find column - although column is definitely - correct spelling as used Qrew tools to copy in etc

The formula works in the field above - There is no valid reason why its not picking up the column. the relevant field is not in CAPS either .
Doing my head in - I tried renaming in both tables and re-gen structure
Any help appreciated
cheers

AY

AY2450:

I tried renaming in both tables and re-gen structure

Can you please elaborate?

1 Like

Sorry - I edited my post and it was added as a comment
There is more to my original post including screenshot - trying to Total DMI in a table from entries in another and it is unable to find my column - yet the column exists and is correctly named in the expression.

I managed to sort it - It didn’t Like long the Field name - Event though I copied it using QREW tools - I simplified it just to DMI and it picked up the column without issue.