Code Help Required

[aveeeeeee7en]

Hi Everyone

I need help on Coding Part.

See the Attachment.

[sujeetsingh]

Plz explain what you want

[aveeeeeee7en]

I want to calculate

Opening MOB:

If(RecNo()=1,MOB-Joining+Leaving,Peek(OpeningMOB)-Joining+Leaving) AS OpeningMOB

Closing MOB:

(RecNo()=1,MOB,Peek(OpeningMOB)) AS ClosingMOB

But I am not getting the result.

[vardhancse]

Can you let us know what you are trying to achieve.

[aveeeeeee7en]

Current I have found Current Month & Current Year Man On Board (MOB) in a Company and it is coming 998.

Out of this figure, I am applying logics to find the value of Man On Board (MOB) by using the formula

Man On Board (MOB)-Joining+Leaving  for different Month & Years.

which is not working.