6 Replies Latest reply on Apr 25, 2018 9:53 AM by Cynthia Derksen

Help! My Between Calculation not working

I have a dataset with process time per date. I'm trying to flag each day by the amount of hours we have with 'Limited' and 'Available'.

For example, if my process time for 1/22 is 300 hours, I'd like to mark that as 'Limited' as we've reached our maximum hours for that day. If however, the next day, 1/23 the process time is only at 200 hours, then I'd like to mark that as 'Available'.

This is what I have as my calculation:

IF [Process Time] > 250 THEN "limited"

ELSEIF [Process Time] >= 0

AND [Process Time] <= 250

THEN "Available"

END

But my outcome shows all as available. See attached.

I'm stumped! Any help is much appreciated! Thank you.

• 1. Re: Help! My Between Calculation not working

Can you attach a sample workbook? Just a few rows of limited/available data will do!

• 2. Re: Help! My Between Calculation not working

if your process time is a measure you are summing up, make the calculation

IF sum([Process Time]) > 250 THEN "limited"

ELSEIF sum([Process Time] )>= 0

AND sum( [Process Time] )<= 250

THEN "Available"

END

or make it Attr([Process Time]) instead of Sum - if it a direct value

1 of 1 people found this helpful
• 3. Re: Help! My Between Calculation not working

Just attached! Thank you!

• 4. Re: Help! My Between Calculation not working

Thank you! This worked!

• 5. Re: Help! My Between Calculation not working

It's figured out. Thanks for your help!

• 6. Re: Help! My Between Calculation not working

I have been trying to do something similar.  Would you please look at it?  I am trying to color the background of the table. This is version 10.2

Since I created this version, I have tried so many different things.  I am now lost.