Why am I getting incorrect sum when I sum up two different calculated fields
where Final TI = TI (prorated) + prorated amount add end dt
Calc_prorated_TI =
prorated_amount_add_end_dt
TI for Month - End Date:
1 answer
Hi Akshay,
Try wrapping your calcs in sum() i.e.
SUM([Calc Pro rated TI]) + SUM([TI for month-end date])
HTH
Peter
