hoagieryder
MIS
I have two fields in GH5 of my report that are weighted averages of two formula fields.
Field 1 = Weightedaverage(@formula1,@forumla2,GH5)
Field 2 = Weightedaverage(@formula1,@formula3, GH5)
formula1 = If field.NA = "Y" then 0 else field.rate
formula2 = If field.date = 9/30/2009 then 0 else field.balance
formula3 = If field.date = 12/31/2009 then 0 else field.balance
These fields seem to be calculated correctly, however when I try to find the difference of the two numbers it is not calculated correctly. Is there a way around this?
Field 1 = Weightedaverage(@formula1,@forumla2,GH5)
Field 2 = Weightedaverage(@formula1,@formula3, GH5)
formula1 = If field.NA = "Y" then 0 else field.rate
formula2 = If field.date = 9/30/2009 then 0 else field.balance
formula3 = If field.date = 12/31/2009 then 0 else field.balance
These fields seem to be calculated correctly, however when I try to find the difference of the two numbers it is not calculated correctly. Is there a way around this?