Boy do I feel stupid. I have two formula numeric fields, we'll call them "those months" and "this month". These two fields record the numeric value in a record if the formula criteria are met. In a summary report they both return proper totals. The third formula numeric field looks like this . . . [those months] + [this month] . . . and in the same summary report it returns squat, just a big empty field. Surely it's a simple fix but I can't get on my own, please help.
Thanks,
Rp
 0 Points
Posted 4 years ago
QuickBaseCoach App Dev./Training, Champion
 65,806 Points
 0 Points
More thanks!
Rp
QuickBaseCoach App Dev./Training, Champion
 65,806 Points
 0 Points
Field Name: "Month  Prior Months Total Target" Formula: If([Month  Prior]=true,[Target Total])
Filed Name: "Month  Current MTD Total Target" Formula: If([Month  Current]=true,[Target Total]*[Month  percent passed])
Filed Name: "YTD Total SIP Target" Formula: [Month  Prior Months Total Target]+[Month  Current MTD Total Target]
The first two seem to be working fine, the last one is causing the problem. In the spirit of thoroughness, the formula for the field referenced in the second formula is:
Filed Name: "Month  percent passed" Formula: If([Month  Current]=true,[Month  Day num]/[Month  days in each])
QuickBaseCoach App Dev./Training, Champion
 65,806 Points
If([Month  Prior]=true,[Target Total])
If the month prior is false, then this formula is silent on the result  which makes it null. You need to have these formuals all calculate to "else zero" if they do not pass the test.
If([Month  Prior]=true,[Target Total],0)
If([Month  Current]=true,[Target Total]*[Month  percent passed],0)
That should fix it.
 0 Points
 80 Points
First formula is Quantity 1*Unit Price 1 (shows result in Amount 1 field)
Second Formula is Quantity 2*Unit Price 2 (shows result in Amount 2 field)
Third formula is Amount 1+Amount 2 (suppose to show results in Total Purchase Order)
Third formula is the one that comes back as 0 even when there are amounts showing if fields Amount 1 or Amount 2.
QuickBaseCoach App Dev./Training, Champion
 65,806 Points
 80 Points
QuickBaseCoach App Dev./Training, Champion
 65,806 Points
You could try making the field over again from scratch just to be sure that the third field was not corrupted on some weird way.
Related Categories

Formulas & functions
 2936 Conversations
 76 Followers

Reports & charts
 3099 Conversations
 93 Followers

Tables & fields
 7222 Conversations
 182 Followers