New Field Requirement

[aveeeeeee7en]

Hi All

I want to get the Required field row from Closing MOB Field Values:

Average of Closing MOB in New Field

Month	Closing MOB	Required Field by using CLOSING MOB Field values
Jan	1026	1,026
Feb	1025	1,026
Mar	1027	1,026
Apr	1032	1,028
May	1040	1,030
Jun	1034	1,031
Aug	1015	1,028
Sep	1016	1,026
Nov	1005	1,023
Dec	1002	1,021

Regards

Aviral

[tresesco]

Your script solution is here:

Load
Month,
[Closing MOB],
RangeSum([Closing MOB],Peek('CummClosingMOB')) as CummClosingMOB,
RangeSum([Closing MOB],Peek('CummClosingMOB'))/RowNo() as ExpClosingMob

;

Load * Inline [
Month,"Closing MOB"
Jan,1026
Feb,1025
Mar,1027
Apr,1032
May,1040
Jun,1034
Aug,1015
Sep,1016
Nov,1005
Dec,1002

];

Drop field CummClosingMOB;

[aveeeeeee7en]

Hi Tresesco Sir

Your Logic is Perfectly Running.

Your Logics are always Amazing.

One more help I needed from you.

Could you please help me to find the ClosingMoB from Script Level.

I am doing it in Front end which I don't need.

See the Attachment