Row Group total in separate column

Row Group total in separate column

sarooptrivedisarooptrivedi Posts: 42Questions: 13Answers: 2

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.

Answers

  • sarooptrivedisarooptrivedi Posts: 42Questions: 13Answers: 2

    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();

Sign In or Register to comment.