Hi Anu ,
The only calculation I can readily understand is that the Qty column is the Amount column divided by the Rate column !
All the other calculations are to do with date intervals , but none of the standard calculations is matching exactly ; I tried using intervals between April 1, 2014 and December 1, 2014 with a 360 day base , but it does not match exactly.
If you are looking for accuracy , then probably more data will help.
Narayan
Hi Nebu ,Hi:
May be something like this.
Thanks