GrapeCity Forums

The GrapeCity Message Boards
Welcome to GrapeCity Forums Sign in | Join | Help
in Search
Blogs Forums Photos
GrapeCity Forums » Spread for ASP.NET (Web Forms) » Formula Evaluation » Re: Column Footer sum depending on column values from other columns

Column Footer sum depending on column values from other columns

Last post 01-08-2010, 7:43 AM by Amit Pal. 1 replies.
Sort Posts: Previous Next

  •  01-08-2010, 3:06 AM 86368

    Column Footer sum depending on column values from other columns

    Reply Quote

    Hi!

    How do I archieve a column sum in the column footer which does only add values when a value in an other cell has a defined value?

     

    -> e.g.  the column footer of cell   c   is set to "sum{0} > this calculates the totals of all rows in cell c . 

    But I just want to calculate the values if the value of cell b is 'FDL'  ?

    How can I archieve this ?

     

    Thanx for assistance 

    Robert

  •  01-08-2010, 7:43 AM 86383 in reply to 86368

    Re: Column Footer sum depending on column values from other columns

    Reply Quote

    Robert,

     

    If you are using an Aggregation type of a model then in that case, Aggregate event of Spread will be fired. In this event, you can check for the corresponding value and then apply the Aggregation based on these values.

    Amit Pal
    Grapecity-Farpoint
View as RSS news feed in XML
     FarPoint Forums Home