Can I divide counts of 2 checkboxes

Question

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.

------------------------------
Thomas Ringkamp
------------------------------

markshnier__you · Answer

Often 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

markshnier__you · Answer

there are many ways to do this,&nbsp; ut try this as a compact syntacx.Count([ABC?]) / Count([XYZ?])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

markshnier__you · Answer

... 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
[email protected]
------------------------------

thomasringkamp · Answer

Many records &nbsp; Tom Ringkamp Sr. Director NGAN, Central Division Office: 470-787-3372 Mobile: 678-554-9958 &nbsp; ------Original Message------... but are your trying to calculate this one record or on the totals of many records?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

markshnier__you · Answer

Can you explain your use case.&nbsp; &nbsp;So you have a Table report with records on it.&nbsp; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Forum Discussion

Can I divide counts of 2 checkboxes

6 Replies

Related Content

Formula checkbox using manual checkbox and lookup formula

Converting delimited text into checkboxes

How to create a pipeline to count records in a table

Using Pipelines to Archive Records Based on Checkbox

Combining AND with OR in Formula Checkbox Field