Jump to content

Formula Error

Recommended Posts

"The supplied ID is malformed. Illegal character 'T' at position 0"

This error keeps on popping up whenever I am trying to create the following formula in the "add calculated item" column for asset trees.

$tag.aggregate(stdDev(), months("US/Central"), durationKey())< -0.04 or $tag.aggregate(stdDev(), months("US/Central"), durationKey())>0.06

I am using the same exact code before (with different number) and it works fine, but when I copy and paste it to somewhere else, I receive this error. Please advise. 

Link to comment
Share on other sites

  • Administrators


I recommend saving your asset group and closing out of it then reopening it.  There could be something that isn't fully saved yet that you are asking for.

Another thing to try is to open the formula in a worksheet and try changing it there.

Hope this helps.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...