Forum Discussion
android1
Post Patron
10 years agoUsing a measure in a calculated column
Hi, I have this calc col -> Punctuality = IF (OTIF[ShiftInTime]<OTIF[TimeFrom]-1/24*.25,"Early", IF (OTIF[ShiftInTime]>OTIF[TimeFrom]+1/24*.25,"Late","On Time" & IF (OTIF[ShiftInTime]>OTIF[Tim...
BhaveshPatel
Super User
10 years agoUse of Parameters would be more appropriate solution in your case.
- android110 years ago
Post Patron
Parameters? Can you tell me how I can do this?
- BhaveshPatel10 years ago
Super User
Can you please provide me a snapshot your dataset and I would be more than happy to provide you exact solution.
- android110 years ago
Post Patron
Here's my file. I had a go at adding a parameter and applying the values in my OT% table to it. Parameter name is OTP%.