rpoelking

The question is, are you trying to determin the rebooked % of sport 1 over a number of records (leaugues?) or the rebooked % for sports 1-15 for a record (1 league)? Case 1 Patterncount (Sport1, "Yes") / Status(currentfoundcount) Case 2 Patterncount (Sport1 & Sport2 & ... & Sport15, "Yes") / 15 I might have misunderstood what you were asking, but I hope this answers your question. The same formulas can be applied for "No" and "N/A"

Thanks for your reply, Vin. But the field is already taking its value list from itself. That still won't target the portal it is related to. I did create a cluge to get to the portal row but it's not pretty.

Gary this is a simple use of a case statement calc. Define a field for Discount as: Case ( Quantity 1 and Quantity 12, "0", Quantity 13 and Quantity 24, ".03", Quantity 25 and Qantity 49, ".05", etc... ) [ December 07, 2001: Message edited by: TheGuardian ]

I have a large portal showing data from specific dates. The portal is only 2 large areas with a scrollbar. Instead of making the user scroll through the portal to find a specific date I wanted to use a value list of those dates to target a portal row. i.e I select Nov 19, 2001 from the list, click a button [go to portal row number (by field?)] and (pow) I jump to Nov 19, 2001 in the portal list. The problem is, I can't find a way to get the index of a selected item in a value list to use as my target to get to the related portal row.

I've run across this scenario more than once and I hope someone has a solution. I have a regular date field and then a calc field that produces just the MonthName and Year from the date field. If I specify the data type to be date then the data appears wrong. So I left it as text. But now I want to return a value list based on that calculation. When I do, the list is alphabetized by the MonthName. How do I get the list of dates to show up in order in the value list?