I'm attempting to use the {averagecost} field in a...
# suiteanalytics
b
I'm attempting to use the {averagecost} field in a saved search with the round function as follows:
Copy code
ROUND({averagecost},1)
however it is just returning null. Is this because {averagecost} is a currency field? If so, how would I convert that to a numeric first? If include {averagecost} in my search as a standalone column it returns just fine.