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
PNI Digital Media
762
comparisons in UltraGridColumn.Formulas
posted

Is there any documentation on the syntax for comparisons in UltraGridColumn.Formula? I am trying to tally a row depending on row values and the following formulas:

    if([StatusColumn]=0, 0, [ActiveQuantityColumn])
    if([StatusColumn]='Ignore', 0, [ActiveQuantityColumn])
    if([StatusColumn]="Ignore", 0, [ActiveQuantityColumn])

always give the value in [ActiveQuantityColumn], I need to ignore them if [StatusColumn] shows "Ignore". [StatusColumn] is an Int32 with display value looked up from an UltraDropDown; the statusID of ignored rows is 0.

Parents
No Data
Reply
  • 53790
    Verified Answer
    posted

    Hi,

    May I suggest you to use "UltraCalcManager",, because there are some logical functions. Also, please look at the attached example. In the example the last column is logical (wiht IF condition). Please look at this example and if you have any questions do not hesitate to ask me.

    Regards

    UltraGridSummaryFooter.rar
Children
No Data