Scratching my head over this.

I don’t know how to get rid of this error. Any help is appreciated.


What could be possibly wrong with this?

Hello

I supposed total_miles_for_job are in move details table, and there is no link between this table and the settings table.

If table settings have just one row use the function any(settings[my_setting]) to have the value. Either you have to select te correct row and use function any to have your numerical value

You are right. It worked for me. Thank You!

1 Like