I need the result of this calculation to be = to 1,485.13
My result is 1,484.98. How do I get it to round up?
,round([E].OriginalCost / [TT].contractTotalOrigCost * [FE].GainLoss,2) as [GainLoss]
[E].OriginalCost = 50,000,00
[TT].ContractTotalOrigCost = 50,500.00
[FE].GainLoss = 1,499.98
50,000 / 50,500 * 1,499.98 = 1,484.98 Should be 1,485.13