Results 1 to 2 of 2

Thread: DistinctCount Formula

  1. Aug 23rd, 2005, 02:43 AM #1
    ielashi
    ielashi is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2005
    Location
    Cairo, Egypt
    Posts
    275

    DistinctCount Formula

    Hello,
    I was looking for a formula where it would distinctcount [fieldname1] and if the field [Attend] equals "absent" it would subtract one. I tried doing it several times but can't get it right. Any ideas?
    Reply With Quote Reply With Quote
  2. Aug 23rd, 2005, 11:51 AM #2
    ielashi
    ielashi is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2005
    Location
    Cairo, Egypt
    Posts
    275

    Re: DistinctCount Formula

    Nevermind, used two fields to solve the problem.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width