add totals from 2 fields (duh?)
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 s...
Forum Discussion
I am trying to add together the results in 2 simple multiplication formula fields and the result in the addition formula field is coming back as 0 and don't know why.
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.
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.
