Hello,
I am calculating using Time Difference (days) how long an Activity has been open or was open before completion. I have nested it inside the Decode function in order to account for the 2 scenarios of Actual Finish being Null or populated with a completion date. The user is unable to accurately sort the result of the Decode because it handles it like a string and does not put them in chronological order. So I have nested the Decode inside the To Number function. This allows the numbers to be sorted properly. The numbers bring back along of decimal places so I wanted to restrict that to 2 decimal places and tried encasing the entire thing inside the Round function. When I add the Decode function inside the To Number function I get the error “Attributes of data type string are not valid for this function”. Does anyone know why that error would be produced? The To Number outside of the Decode functions correctly and sorts correctly as a number. But when I try the entire thing inside the Round is when I get an error.
This works correctly......
When I try to do the Round function as the outer function on all of the above, adding the Decode function below the To Number function is when the error pops up.
Thank you!
Hi @cmhaka
If you use the round, don't you need to define a second variable what is the length?
I miss the length in your example.
PS> write the full error message
PetrH
Hello @HelesicPetr
Thank you for your response. I apologize that my second screen print didn't show the entire intended outcome. Here is the intended solution and it is working now that I completed it.
But when I build it I receive the following error when I add the Decode line and when I add the Null line.
Yesterday I stopped at the error. But today I clicked OK on the error box and kept building to see if it would work. It is working despite the error boxes. So I am not sure why the error boxes are popping up.
cmhaka
