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 Reply Children