Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Calculation (2000)

    I have a calculation to perform on a form. This is what I received: Sales Probability will be expressed as a percent and calculated as follows:
    The sum of (if Uniform Health Benefit Plan is "Yes" then .5, if "No" then 0) + (if eMaterials is "Yes" then .2, if "No" then 0) + (If Member Self Serve or Employer Portal or IFF?834 is "Yes" then .15, if Member Self Serve and Employer Portal and IFF/834 are "No" then 0) = (if eBill is "Yes" then .15, if "No" then 0).

    What would be the correct syntax for such a calculation? I would put a text box on the form and put its control source to = sum (and the rest). Can I do this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Calculation (2000)

    Sum is used to add values across all records; I think you want to add some values for a single record here, so Sum wouldn;t be appropriate. Try this as control source for the text box:

    =IIf([Uniform Health Benefit Plan], 0.5, 0) + IIf([eMaterials], 0.2, 0) + IIf([Member Self Serve] Or [Employer Portal] Or [IFF/834], 0.15, 0) + IIf([eBill], 0.15, 0)

    I have assumed that the fields you mention are Yes/No fields, and that ? and = are typos.

Posting Permissions

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