Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi Riyaz, I was able to add the OVER PARTITION clause to my Data Model query and works exactly how I want. Had to modify with NULLIF, due to a DIVISOR = 0 error, which is due to the underlying data. SUM(INVOICE_AMOUNT)/SUM(NULLIF(SUM(INVOICE_AMOUNT), 0)) OVER (PARTITION BY PERIOD_NAME)*100 Thank you for your timely…