Comments
-
Here is the beastmode that is being used SUM(CASE WHEN SUM(Loads) * (SUM(carrier pay)/ SUM(Loads)-Dat Avg CPL) > 0 THEN SUM(Loads) * (SUM(carrier pay)/ SUM(Loads)-Dat Avg CPL) Else 0 END)OVER (PARTITION BY LastdayofMonth) And ive also removed all the filters. I am still getting this.
-
That solved the issue. I knew it was a simple mistake and I couldn't figure it out. Thanks for teaching me something new.
-
@MichelleH Thank you for the fast response! This worked!
