CORRECT THIS FORMULA CASE WHEN TYPE " ITEM RECEIPT" THEN {quantity}-{inventorydetail.quantity} AND TYEP "BILL" THEN quantity}-{inventorydetail.quantity}

AI generated answer (using internal Slack threads):

The formula you provided seems to have a typo and lacks proper structure. The corrected formula should look like this:

CASE 
WHEN {type} = 'Item Receipt' THEN {quantity}-{inventorydetail.quantity} 
WHEN {type} = 'Bill' THEN {quantity}-{inventorydetail.quantity} 
END

Please note that this formula assumes that the

{type}

field can only have 'Item Receipt' or 'Bill' as its value. If there are other possible values for

{type}

, you might want to handle those cases as well. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******