Can I divide counts of 2 checkboxes
I am trying to calculate a percentage based on the counts of 2 checkboxes. I tried this: ToNumber([ABC?])/ToNumber([XYZ?]) But it didn't work. Any help would be greatly appreciated. ---------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legend... but are your trying to calculate this one record or on the totals of many records?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Many records
Tom Ringkamp
Sr. Director NGAN, Central Division
Office: 470-787-3372
Mobile: 678-554-9958
------Original Message------
... but are your trying to calculate this one record or on the totals of many records?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- MarkShnier__YouCan you explain your use case. So you have a Table report with records on it. Can you explain what ABC is and what XYZ is? I have to understand from your use case if an arithmetic average is OK or does this need to be a weighed average.
Also can XYZ be zero?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------I have a Table that contains checkboxes of construction issues, things like permits, access, etc. I then have fields that have a number of HP in them if the box is checked. That allows me to see how many HP are affected by the various issues.
I am trying to put a report formula together to calculate the percent to total for permit issues, access issues etc.
------Original Message------
Can you explain your use case. So you have a Table report with records on it. Can you explain what ABC is and what XYZ is? I have to understand from your use case if an arithmetic average is OK or does this need to be a weighed average.
Also can XYZ be zero?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- MarkShnier__YouOften asked, but not yet available, is the ability to do arithmetic calculations between columns on a summary report.So the best solution at this time is to make summary fields up to the parent level which in your case would seem to be the Node Name, And do your calculations up there.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------