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
455
Can I use a group summary in a formula for a calculated unbound column?
posted

My bound grid columns are: CITY, SALESPERSON, TOTALSALES

I added a group summary by CITY so I now have SUM(TOTALSALES) for each city.

I am trying to calculate each salesperson's percentage of sales in their own city, so I want to divide their totalsales by the sum(totalsales) for that city group. is that possible in a formula?

I added a calculated unbound column, I want its formula to be [TOTALSALES] / SUM(TOTALSALES) PER CITY. not for the whole dataset.

 

I saw in some samples the use of double slashes //  and (*) but i couldn't find any documentation that explained the different special characters that can be used in formulas or how to reference different groups, bands, or summary rows.

 

Any help is appreciated.

Parents
  • 469350
    Offline posted

    When you added your Summary to the grid, did you specify a Key for it? If so, you can simply use that Key value in the formula for the unbound column and it should return the total for that particular island of rows.

    So the formula would be:

    ([TotalSales] / [key of summary]) * 100

Reply Children