My columns are grouped (Designer->Groups and levels). I'm trying to create "Totals" column which will contain sum of values from same row and same group.
I can't figure out how to address cells in same group - orindary sum([column1],[column2],...) does not work (it worked before column grouping). Already tried: //grid/band_name/column_name, //grid/band_name/Groups(2)/column_name and //grid/band_name/Groups(2)/Level0/column_name none of them seem to work.
Picture of column structure which I mean (Production has index =2):
Hi,
dynacon8 said:I can't figure out how to address cells in same group - orindary sum([column1],[column2],...) does not work (it worked before column grouping).
Groups have no effect on formulas. You reference the column by it's key. So if it worked before you added groups and no longer works, then my guess is that something else changed in addition to the groups.