Forum Discussion
Switch statement issues
ACTUAL WORKING DAYS PERFORMANCE = SWITCH ( True(), --[Actual Working Days] = blank(), "null", [Actual Working Day] < -19 , "Late 20+ days", ([Actual Working Day] <= -11 && [Actual Working Day] >...
Bucket is not allined with actual working days :-
Actual working day is calcualted column .
Actual working days :- X-Networkingdays here x is also a column from same table and networking day is calculated column .
ACTUAL WORKING DAYS PERFORMANCECommunity = SWITCH (
True(),
--[Actual Working Days] = blank(), "null",
[Actual Working Day] <= -20 , "Late 20+ days",
([Actual Working Day] < -10 && [Actual Working Day] > -20 ), "Late 11-19 Days",
([Actual Working Day] <= -6 && [Actual Working Day] > -11), "Late 6-10 Days",
([Actual Working Day] <= -3 && [Actual Working Day] > -6), "Late 3-5 Days",
[Actual Working Day] <= -1 , "Late 1-2 Days",
[Actual Working Day] = 0, "OnTime",
([Actual Working Day] >= 1 && [Actual Working Day] <= 2), "Early 1-2 Days",
([Actual Working Day] >= 3 && [Actual Working Day] <= 5), "Early 3-5 Days",
([Actual Working Day] >= 6 && [Actual Working Day] <= 10), "Early 6-10 Days",
([Actual Working Day] >= 11 && [Actual Working Day] <= 19), "Early 11-19 Days",
[Actual Working Day] >= 20 , "Early 20+ Days", "Unknown")