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
Rui
370
Column Average If Other Column is >0
posted

Hello,

I have this WinGrid and I want to add the following summaries to Col A:

 

 

  • Average 
    • if Col B >0, 
    • if Col B>=0 and Col B<=100
  • Standard Deviation
    •  if Col B>0
    •  if Col B>=0 and Col B<=100
  • Median
    •  if Col B>0
    •  if Col B>=0 and Col B<=100

How can I implement this? With formulas or do I need something else?

Thanks in advance.

 

 

Parents
No Data
Reply
  • 370
    posted

    I just figured it out how to do it.

    I have another question:

    • How can I replace the "Nan" caption for a 0 or empty string?

     

     

Children