Sum Field when Expression

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

    Posted 05 Mar Link to this post

    Hello,

    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  

    Thanks.

  2. Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 09 Mar 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))

    Regards,
    Nasko
    Telerik
    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. DevCraft banner
Back to Top