Sum Field when Expression

3 posts, 0 answers
  1. Islam
    Islam avatar
    2 posts
    Member since:
    Mar 2016

    Posted 05 Mar 2016 Link to this post


    i have a field returning Boolean Value (True/False), and i want to Sum another field Named (Total) in the footer section when my Boolean Value return TRUE for each record in the detailed section  


  2. Nasko
    Nasko avatar
    1051 posts

    Posted 09 Mar 2016 Link to this post

    Hello Islam,

    You need to sum the Total field conditionally. For this purpose you can use the IIf() conditional function:

    = Sum(IIf(Fields.BooleanField = True, Fields.Total, Null))

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Rod
    Rod avatar
    14 posts
    Member since:
    May 2010

    Posted 05 Jun in reply to Nasko Link to this post

    Thank you! I don't know why I did not think of this myself. It would be a great example in the docs because I have run into this situation before. I need to bookmark this one.
Back to Top