Sum If Function
I'm about done on my first build using Quickbase, I'm looking for something similar to a sumif function where I can summarize a sequence of number fields on a record where I only want to add up number...
Forum Discussion
try this
if([Change Stucco Price]>0,[Change Stucco Price],0)
+
If([Change Stone Price]>0,[Change Stone Price],0)
+
etc for all the rest.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks that worked and was much simpler than the path I was taking. Sometimes I get so deep into the weeds of the problem that I don't do the easiest solution.
------------------------------
Paul Elliott
------------------------------
------------------------------
Paul Elliott
------------------------------
