Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
165
SummaryType.Formula is not working in Groupby row summary
posted

I've a Grid which is groupd by Department column and contains summary, summaries would be displayed in bottom as well as Group by row footer. one of the summary is not showing any value in group by footer but it shows correct value in grand summary.

If you look at the below grid, sumary for Short is having value in Grand Summary but not in Grouby footer.

Short is calculated using (sum[Allowence] - sum[Claim])

 

Actual Result

Department : 1
Emp Name             Allowence                                 Claim
Kumar 1000 700
Ravi 1000 600
Total Claim : 1300
Short : 
Department : 2
Emp Name             Allowence                                 Claim
Hari 1500 1400
Somu 1500 1500
Total Claim : 2900
Short : 
Grand Summaries
Total Claim : 4200
Short : 800

 

 

Expected Result

Department : 1
Emp Name           Allowence                                 Claim
Kumar 1000 700
Ravi 1000 600
Total Claim : 1300
Short : 700
Department : 2
  Emp Name          Allowence                                Claim
Hari 1500 1400
Somu 1500 1500
Total Claim : 2900
Short : 100
 
Grand Summaries
Total Claim : 4200

Short : 800

Parents
No Data
Reply
  • 53790
    posted

    Hi,

    I have created small sample based on your requirements. Please take a look at it and let me know if this is what you are looking for

    GridSummary.rar
Children
No Data