An issue has occurred during processing. We are unable to complete the request at this time.
Hi I am new to Domo and have no SQL knowledge. I am trying to get our YTD cases quantity with some condition taken from other working beast mode. If someone can please help me figure the beast mode below why it's erroring. Thank you ion advance.
SUM(CASE WHEN `Year`=2020 AND `Month #` <=`Month # for Today`
WHEN `Unit price`>100 THEN ((`SO Ordered Qty`)*`Cases per Pallet`)
ELSE (`SO Ordered Qty`)