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
180
Grid with Formula and Summary?
posted

I have a grid with  a check box column and an amount column. I created an additional unbound column with the formula:

if( [IsMisplaced] , 0 , [Amount] )

where isMisplaces represents the check box. This works fine, however, when I add a summary operation and point to this column, the formula appears to stop working (all blanks). When I take the summary off it works fine again. Is there an event or something  firing that might be causing this to reinitialize?

Parents
No Data
Reply
  • 130
    posted

    up !

    I have the same problem. I have an UltraWinGrid with 3 columns : Width, Height, Surface

    The last column (Surface) is an unbound column with a formula : [Width] * [Height]

    When I had a summary of type Sum to the last column, the column Surface is not calculated (always empty).

    I have try to find a workaround using formula instead of Sum type for the summary, doesn't works.
    I have tested setting the summary in runtime, after setting AllowRowSummaries to True. And the behavior looks strange for me :
    if there is no summary, the column Surface is good calculated for all new row I add, but once I had the Sum summary to the column Surface, every new row I add has an empty cell Surface...

    any idea ? please.

Children