Can I use a group summary in a formula for a calculated unbound column? | Infragistics Forums

State See Verified Answer
Replies 7 replies
Subscribers 7 subscribers
Views 2021664 views
Users 0 members are here

455

Can I use a group summary in a formula for a calculated unbound column?

Talal Nehme posted over 14 years ago

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.

469350

Offline Mike Saltzman posted over 13 years ago in reply to Talal Nehme

Hi,

I don't think this is currently documented in detail. This was an oversight in the docs that will be corrected in NetAdvantage 10.3.
Cancel
Reply

Cancel
455

Offline Talal Nehme posted over 14 years ago in reply to Mike Saltzman

Mike,

Thank you the parenthesis fixed the problem.

Any idea where I can find documentation on these special characters used in formulas?
Cancel
Reply

Cancel
455

Offline Talal Nehme posted over 14 years ago in reply to Mike Saltzman

Mike,

Thanks for the reply I will try that today to see if it works,

Where can I find the documentation for this syntax, I saw in some other posts that formulas for the wincalcmanager accept certain characters like /// etc..but couldn't find any documentation listing all the accepted syntax, for example the parenthesis you just mentioned,

Thanks
Cancel
Reply

Cancel
469350

Verified Answer
Offline Mike Saltzman posted over 14 years ago in reply to Talal Nehme
Hi,

Sorry, I forgot that summary references have a slightly different syntax. Since you could have a column and a Summary in the same band with the same key, the CalcManager needs to be able to distinguish between the two. So you can't just use the name of the summary, you have to put parens after it to indicate it's a summary and not a column.

cccol.Formula = "[TOTALSALES] / [TOTALSALESSum()]"
Cancel
Reply

Reject Answer

Cancel
455

Offline Talal Nehme posted over 14 years ago in reply to Mike Saltzman
Mike,

That was what I thought initially but I got a #REF! in the rows

I was wondering if this is because I am grouping, so I removed the line that adds a sorted column for grouping and I still get the #REF!

Here's the simplified code from the grid's InitializeLayout:

For Each c As Infragistics.Win.UltraWinGrid.UltraGridColumn In e.Layout.Bands(0).Columns
   c.CellActivation = Activation.NoEdit
   If (Microsoft.VisualBasic.Right(c.Key, 2) = "ID") Then
      c.Hidden = True 'Hide ID Columns
   ElseIf (c.Key = "TOTALSALES") Then
      c.CellActivation = Activation.AllowEdit
    e.Layout.Bands(0).Summaries.Add(c.Key & "Sum", SummaryType.Sum, c)
   End If
Next c

e.Layout.Bands(0).SummaryFooterCaption = "TOTALS"
'e.Layout.Bands(0).SortedColumns.Add("CITY", False, True)

Dim cccol As Infragistics.Win.UltraWinGrid.UltraGridColumn
cccol = e.Layout.Bands(0).Columns.Add("CalcCol")
cccol.Formula = "[TOTALSALES] / [TOTALSALESSum]" 'Percentage of TOTALSALES

e.Layout.Bands(0).Summaries.Add("CalcColSum", SummaryType.Sum, cccol)

'

In the FOR EACH statement I handle other formatting issues for other columns that i didn't list here.

this is why I am assigning the summary key as (c.Key & "Sum") for each column I add a summary to.

But I thought that would be ok, is it?
Cancel
Reply

Cancel