Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: Formula Help Needed

    Hi

    I have a field called SOP_Item_Due_date that if unpopulated I would like it to equal another field called Sales_Order.Delivery_Date or if populated to equal itself. I have various if then else statements, but keep getting syntax errors.

    Please help

    kltmacd

  2. #2
    Join Date
    Dec 2004
    Location
    Connecticut
    Posts
    85
    I'll assume you've added a calculated field to your report to take the place of SOP_Item_Due_date.

    The formula for the new field will be something like this:

    if IsNull({SOP_Item_Due_date})
    then {Delivery_Date}
    else {SOP_Item_Due_date}

    I'm a lousy typist, so I get less syntax errors when I choose items from the builder list than if I type even the simplest formula.

    If you post some of the failed formulas, we may be able to whip them into shape.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •