Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
3 years ago
Solved

Goal by Hour

I'd like to a measure calculation  so that if its the 6am and 10pm shift, the goal is # of people working X 7.5, if it's the 10am, 2pm, and 6pm block, the goal is number of people working X 10,  all ...
Need Help
  • rsbin's avatar
    rsbin
    3 years ago

    jcastr02 ,

    Create a new Calculated Column using the SWITCH function:

    Goal2 = SWITCH(
           TRUE(),
           OR( [Hour] = Time(6,0,0), [Hour] = Time(22,0,0 )), [# of People Working]*7.5,
          OR( [Hour] =Time(10,0,0), OR( [Hour] = Time(14,0,0), [Hour] = Time(18,0,0))), [# of People Working]*10,
          [# of People Working]*15 )

    Trust this is what you are looking for.

    Regards,

rsbin's avatar
rsbin
Community Champion
3 years ago

jcastr02 ,

Create a new Calculated Column using the SWITCH function:

Goal2 = SWITCH(
           TRUE(),
           OR( [Hour] = Time(6,0,0), [Hour] = Time(22,0,0 )), [# of People Working]*7.5,
          OR( [Hour] =Time(10,0,0), OR( [Hour] = Time(14,0,0), [Hour] = Time(18,0,0))), [# of People Working]*10,
          [# of People Working]*15 )

Trust this is what you are looking for.

Regards,