Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a variable called vAHTCalc and need to show this formatted as a variable to show seconds.
I have created what I believe to be the correct expression as below but get an error 'Error: Error in expression: ')' expected.
=Interval($(vAHTCalc),'ss')
I'm just trying to display this in a text box for now so not doing anything too complicated. What am I missing?
What is in the variable? What you see in a text box if you use just
=vAHTCalc
I agree with Mich and i just doubt that, the variable will always have a single value hence is it like you want a same value in your UI.
That sounds like your variable doesn't return a number but a text value.
I suspect it is a text of expression, but what do I know?
Its an interval. I think I've got a formatting problem as I've now fixed that issue by changing the expression of the variable to an interval but now I want to divide 3600 by said variable (interval) and I'm back to 'Error: Error in expression: ')'
=num(3600/$(vAHTCalc),'##.##')
Not sure I can what I'm trying to do
Thanks
Gavin
You can, if you do it right... Again, what is in the test box if you try
=vAHTCalc
?