Sum Field when Expression

2 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
    944 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
Back to Top