Forum Discussion
- QuickBaseCoachDQrew CaptainAre you looking to treat a null as a zero? Can you tell e the type of field you are totaling. is this a data entry field or a formula field or a summary field.
- CasameiraReyesQrew CadetIt is a formula field. I don't want it to equal zero because it will hurt the score.
- QuickBaseCoachDQrew CaptainIs this a Total or an Average? if it is a total, then the zero will not hurt the total as it will be zero.
- CasameiraReyesQrew CadetHere is the formula: ([Section Total:]* 0.05)+([Section Total]*0.25)+([Unnamed 5]*0.1)+([Unnamed 6]*0.03)+([Unnamed 7]*0.12)+([Unnamed 8]*0.15)+([Unnamed 10]*0.25)+([Section Total;]*0.05)
- QuickBaseCoachDQrew CaptainTry this
nz([Section Total:]* 0.05)
+nz([Section Total]*0.25)
+nz([Unnamed 5]*0.1)
+nz([Unnamed 6]*0.03)
+nz([Unnamed 7]*0.12)
+nz([Unnamed 8]*0.15)
+nz([Unnamed 10]*0.25)
+nz([Section Total;]*0.05) - CasameiraReyesQrew CadetI had tried this originally and it doesn't work
- QuickBaseCoachDQrew CaptainWhat do you mean by "it does not work". Syntax error or incorrect totals?
- CasameiraReyesQrew CadetI'm sorry I am getting the same result of blank
- QuickBaseCoachDQrew CaptainCan you post your formula?
- CasameiraReyesQrew CadetNz([Section Total:]* 0.05)
+Nz([Section Total]*0.25)
+Nz([Unnamed 5]*0.1)
+Nz([Unnamed 6]*0.03)
+Nz([Unnamed 7]*0.12)
+Nz([Unnamed 8]*0.15)
+Nz([Unnamed 10]*0.25)
+Nz([Section Total;]*0.05)