Try this: ```case when max(nvl({quantityshiprecv},...
# suiteanalyticsk
KevinJ of Kansas
07/25/2019, 9:18 PMTry this:
Copy code
case when max(nvl({quantityshiprecv},0))>0 THEN SUM({grossamount})/( nullif(COUNT(DISTINCT({fulfillingtransaction.internalid})),0) ) else sum({grossamount}) end