that said, my best guess would be something like t...
# suiteanalytics
k
that said, my best guess would be something like this:
Copy code
1-  (sum({item.cost}*quantity})/nullif(sum(nvl({amount},0),0)))