getsummary() blank

[No_access]

getsummary() not working

 

Ok, this should be simple..

I have a report

with several sub-summary parts.

one part is sub-summay by _AccountID.

on this part is 3 summary fields.

sumisinrange14

sumisinrnage13

sumisinrange12

 

I need to add these together.

so I added a calculation field

GetSummary (sumisinrange14 ;_AccountID)

 

this should show the sumisinrange14 field. but it is blank.

 

the sort order is

Accountnumber

_accountID

productgroupPeraccount2

 

so the sort is there but the getsummary feld is blank

 

[No_access]

ok. I got it. after getting away from it for a while.  needed to add relationship and access that way.

[comment]

Summary fields summarize the found set; relationships ignore found sets. Mixing the two methods can easily produce unexpected results. I see no reason why your original calculation should not work (meaning that the reason is not to be found in what you shared with us so far).