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
435
Or Condition in Summary Formula
posted

Hi All,

In WinGrid summary i want to check 2 condition

If (Sum([col1]) > 100 or Sum([col1])  < 200 then Sum([col1]) *.5 else Sum([col1]) *2

Please tell me how to achive this formula.

Thanks

Amit

 

Parents
No Data
Reply
  • 469350
    Suggested Answer
    Offline posted

    Hi Amit,

    What part of this is giving you trouble? The formula you have here looks pretty good to me. You just have change it around a little because the 'if' function syntax is a bit different than in code.

    if (Sum([col1]) > 100 or Sum([col1])  < 200, Sum([col1]) *.5, Sum([col1]) *2)

Children
No Data