Posted by scott on December 12, 2001 5:57 PM
Heres what im facing
Credit benchmark: credit amount: Difference:
1000 1200 200
1000 1100 100
I need to create a formula that will do the following-
1.) Calculate the difference between the "credit benchmark" and the "credit amount" ONLY, I repeat ONLY if there has been a "credit amount" entered.
In this example we see there is no "credit amount" for the middle row. In this case I do not want a value returned, or to return a "0" value.
At the bottom of the table I will have a section which is labeled "credit benchmark YTD vs. credit written YTD" I can do that part by simply summing the values in the "difference" column.