Hey community! Hoping someone can help me craft what must be a simple custom formula in a summary report that I just can't figure out.
In my screenshot, I have a simple summary, and what I'm trying to do is calculate the percentage of "confirmed" and have it as a live percentage. I need to divide the confirmed count into the sum of all the dispositions.
I figured out the (Contains([Cashflow],"confirmed")), thinking this may be part of the formula but when I try to get the sum it seems not to take things like "+" or "OR" when trying to sum all of the dispositions.
So need a Report Formula that does this:
[Cashflow],"confirmed" / Sum of ("confirmed","empty","maybe","declined","pending")
or
[Cashflow],"confirmed" / Total of [Cashflow]
for each month, or row
doable?
THANK YOU!
Bobby
------------------------------
Bobby Hollis
------------------------------
Question
Please Help with Percentage Calculation for a Report Formula
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.