
1. Re: Highlighted Calculation
Zhouyi Zhang Jul 27, 2018 7:32 AM (in response to Paco Matt)Hi, Paco
What's the logic in the image of those highlights? it is not in your sample workbook and you didn't mentioned here as well.
e.g. why Room2 Inprogress is not highlighted?
ZZ

2. Re: Highlighted Calculation
Paco Matt Jul 27, 2018 10:36 AM (in response to Zhouyi Zhang)Hi Zhang, thanks for your reply.
I've created the image to represent the calculation scope in the table; the highlighted numbers represent the total of the Highlighted sum that I need first. The calculation field should have the capability to sum Rooms based on specifics status criteria:
If is Room 1 sum(InProgress, OnHold, Started)
If is Room 2 sum((OnHold, Started)
If is Room 3 sum(InProgress, OnHold, Started)
If is Room 4 sum((OnHold, Started)
If is Room 5 sum((OnHold, Started)
If is Room 6 sum(InProgress, OnHold, Started)
Then create a second calculated field to sum all Rooms
Finally a third calculated field to get the percentage.

3. Re: Highlighted Calculation
Zhouyi Zhang Jul 28, 2018 6:31 AM (in response to Paco Matt)
TestingFile (1)_v10.2.twbx 21.1 KB


4. Re: Highlighted Calculation
Paco Matt Jul 30, 2018 11:17 AM (in response to Zhouyi Zhang)ZZ, thanks a lot, this solution helped me. My only observation is that the Calculated Fields are fixed, It apparently take all the Order# from the Data Source and make the calculation instead of filter with my dates range selection. Great support!