Can you share your workbook with sample data
Good morning - see the attached
it returns this
I made 2 changes
first I changed the % total formula as shown and placed it on the detail shelf in place of the the percent field
second I changed you percent formula as shown
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Dashboard_v10.2.twbx 230.1 KB
Thank you so much Jim !
I just tried making the second change, mentioned above, in my workbook and it worked perfectly. I didn't have to add % Total calculation at all, to the workbook.
Can you please help me understand how did 'ATTR' changing to 'MIN' in % Uptime calculation made difference? This is great!
Glad to help out.
This is a case where you want the actual number to use in calculation - therefore use min(), Max()
The Attr() function is fine for the string field -
Also I avoid Attr() - it can't be used in LOD expressions and often I will pick up a calculation and drop it into an LOD only to find I have to remove the Attr()
Great! Thanks for the information.
Follow up question -
Why would it have worked for column wise grand total calculation then? I mean how could '% Uptime' have values for grand total by column & just 'not by row'? Just Curious. Thanks in advance.