Row Group total in separate column

sarooptrivedi

Hello Team,

https://datatables.net/extensions/rowgroup/examples/initialisation/startAndEndRender.html

Please refer this link. I need to create the one more column with Total Average Salary which has same value like row group average value. The column value is base on row group.

So when user search the some value then column value change same as the row group average salary change.

sarooptrivedi

I need to search the total average salary in search Builder and it is only way I add new column. My code is on serverside scripting

var response = new Editor(db, "Table1",pkey)
.ReadTable("MyView")
.Field(new Field("SNo")
.Validator(Validation.NotEmpty()))
.Field(new Field("FullName"))
.Field(new Field("SampleId").Validator(Validation.Numeric())
.SetFormatter(Format.NullEmpty()) )
.Field(new Field("OldAirSampleID").Validator(Validation.Numeric()))
.Field(new Field("DecayKey").Validator(Validation.Numeric()))
.Field(new Field("DateOn").Validator(Validation.DateFormat("yyyy-MM-dd"))
.SetFormatter(Format.NullEmpty())
.GetFormatter(Format.DateSqlToFormat("yyyy-MM-dd"))
.SetFormatter(Format.DateFormatToSql("yyyy-MM-dd")))
.Field(new Field("PF").Validator(Validation.Numeric()))
.Field(new Field("EffDACFraction").Validator(Validation.Numeric()).SetFormatter(Format.NullEmpty()))
.Field(new Field("EffDACHrs").Validator(Validation.Numeric()).SetFormatter(Format.NullEmpty()))
.Field(new Field("DecayEFFDACFraction").Validator(Validation.Numeric()).SetFormatter(Format.NullEmpty()))
.Field(new Field("DecayEFFDACHour").Validator(Validation.Numeric()).SetFormatter(Format.NullEmpty()))
.Field(new Field("QuarterNo").Validator(Validation.Numeric()).SetFormatter(Format.NullEmpty()))
.Field(new Field("SampleYear").Validator(Validation.Numeric()).SetFormatter(Format.NullEmpty()))
.Field(new Field("SumDACFrac").Validator(Validation.Numeric()).SetFormatter(Format.NullEmpty()))
.Process(Request)
.Data();

sarooptrivedi

I am facing similar issue
https://datatables.net/forums/discussion/53247/how-editor-returns-sum-of-column