Forums Ultimate UI for Windows Forms
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
Close
Milton
360
How can i compare a string value with wincalc funtions?
posted

i want to compare it a column has a certain string value, if yes sum the value of another column if not doesn sum anything.

how can i do that?

Parents
No Data
Reply
  • 469350
    Offline posted

    You want a cell to summary a whole column? That seems odd, since you will end up repeating the same sum in every row.

    But anyway, you can use the 'IF' function to apply a condition.

    IF ( [String Column] = "Some String", SUM([Numeric Column], 0 )

     

Children
No Data