profit calculation require from two column

[yadav_anil782]

Dear All ,

i have value againsed time series(year, month, quarter, day) and other dimentions wise . now i want "actual profit amount" from "Received Collection"- "outgoing amount" with logic(Received Collection-outgoing amount+ previs amount   ) . this logic i attched in excel sheet .

plz helt to create  this logic , i need to show this column in dashboard as a line chart

  note- both column belongs to difrent tables    

Year	Received Collection	outgoing amount	profit amount	actual profit amount
2009	0.00	0.01	-0.01	-0.01
2010	1,421.04	1,643.10	-222.06	-222.07  logic-(1,643.10-(-222.06)+-0.01
2011	441.75	3,083.95	-2,642.20	-2,864.26
2012	651.47	2,182.35	-1,530.88	-4,395.15
2013	868.57	1,572.27	-703.70	-5,098.85
2014	1,326.99	3,194.92	-1,867.93	-6,966.77
2015	259.70	877.47	-617.77	-7,584.54

[MayilVahanan]

Hi

PFA

[yadav_anil782]

HI,

WHERE IS YOUR SOLUTION , I'M NOT ABLE TO  FIND

[yadav_anil782]

Hi Mayil,

your rvert is helpful , i need again calculation in same line chart

i want  future profit line  in chart with the help of given "future collection" column ,

present logic is -    =([Received Collection]-[Paid Amount])+Alt(Above([Net  Amount]),0)

now i want continuew this line for future profit also  so i'm giving this expression  =([Received Collection]-[Paid Amount])+Alt(Above([Net  Amount]),FINAL_AMOUNT-[Net  Amount])