Can anyone see a mistake in this expression:
(([1. Highest Possible WBV (m/s2)][1. Highest Possible WBV (m/s2)])[1. Seconds used today])+([2. Highest Possible WBV (m/s2)][2. Highest Possible WBV (m/s2)])[2. Seconds used today]+([3. Highest Possible WBV (m/s2)][3. Highest Possible WBV (m/s2)])[3. Seconds used today]
I am getting the error message - 'Arithmetic expression ‘([3. Highest Possible WBV (m/s2)]*[3. Highest Possible WBV (m/s2)])’ has inputs of an invalid type ‘Unknown’
And if I remove +([3. Highest Possible WBV (m/s2)][3. Highest Possible WBV (m/s2)])[3. Seconds used today] the formula works fine.
Any suggestions are appreciated.
1 Like
As the error indicated , possibly one or more of the three columns involved in that part where it indicates error are not suitable for arithmetic expression. You may wish to check those column types.
Or you could test the part of the expression ([3. Highest Possible WBV (m/s2)][3. Highest Possible WBV (m/s2)])[3. Seconds used today] separately in another VC that it is calculating properly,
2 Likes
I’ve found it, thanks for your help.
3 Likes
Nice to know that. If possible, you may wish to post the solution so that any future reader of the post thread could benefit.
2 Likes
One of the columns within my expression was set to a ‘Text’ field rather than a ‘Decimal’ which I had with the others.
1 Like