NVL(ROUND(({locationquantityavailable}-{custitem_e...
# general
a
NVL(ROUND(({locationquantityavailable}-{custitem_esp_shopify_reserve_qty})*.8),0) I am getting too many zeros as result. Do I need to change the expression to something else?
r
Remove ROUND function from expression
a
the results should be around 800 so I dont think rounding is going to cut it. if it was closer to 1 then it might have worked unless i am missing something?
r
ROUND ( ( NVL({locationquantityavailable},0)-NVL({custitem_esp_shopify_reserve_qty},0) )*.08 )
Try this
a
Thank you sir @Ramanand Dubey it worked
r
@Amtoj You are welcome!