IF ISNULL([EvClass]) AND [Activity]==8 THEN [SchTime]
Thank you for the reply. The provided LOD is not reading BreakendendTime as Schtime. I want Tableau to read Breakendtime as Schtime when conditions met. Thanks
If [EVCLASS] ='Null' and [ACTIVITY] =8 then [SCHTIME] else [BREAKENDTIME] END
This calculation tries 2 conditions, and returns SCHTIME if conditions are met, or Breakendtime if conditions are not met.