2 of 2 people found this helpful
You were double counting "window_sum"
IF WINDOW_SUM(countd([BOOKINGID]))>=[Total cancellations] THEN "TRUE" ELSE "FALSE" END
[Totalcancellation Threshold Original]
IF WINDOW_SUM([Sum of cancellations])>=[Total cancellations] THEN "TRUE" ELSE "FALSE" END
1 of 1 people found this helpful
Thank you Shin for the help. It works for me.