This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would imagine that the fixed decimal that you chose was too small and that you received "Conv" error messages that the amount was too long to fit in this FixedDecimal. Making the Fixed Decimal 19.2 should fix it.
If that isn't the case, try TrimLeft([SalesVolume],"0") before the conversion to Fixed Decimal.
Also, why not an integer?
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.