I'm pretty sure you cant use variables in views, I have decided to take them out which isn't the end of the world.

I haven't worked out how to create a table on a scheduled task yet but i think the above method is better for this purpose.

Thanks