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 Legendthere are many ways to do this, ut try this as a compact syntacx.
Count([ABC?]) / Count([XYZ?])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Count([ABC?]) / Count([XYZ?])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
MarkShnier__YouQrew 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
------------------------------
