Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MeganRoss

    Crosstab but no summaries

    I knew i was missing something simple. Thank you.
  2. MeganRoss

    Crosstab but no summaries

    I'm using Crosstab Expert (ver XI) to create a report like a crosstab but i don't need the summaries. The rows will be part # and the column will be customer. The supposed summary would be selling_price. One of the key aspects of the reports is to compare customer pricing and if customer...
  3. MeganRoss

    Is Whole Number?

    That worked. Thank you.
  4. MeganRoss

    Is Whole Number?

    I have to create a formula something like this: if {order_qty}/{case_pack_qty} <> WHOLE NUMBER then "NOT FULL CASE PACK" else "" How do I determine whether or not {order_qty}/{case_pack_qty} actually equals a whole number or if it has a fraction. Basically if it does not divide evenly I need...
  5. MeganRoss

    Counting a formula based on a subtotal

    That did it. Thank you very much!!
  6. MeganRoss

    Counting a formula based on a subtotal

    Close. The only problem is that there are multiple sales rep so I need this formula: @Display110count whileprintingrecords; global numbervar mod110; for each group not the report footer. Would a reset formula work? Any ideas?
  7. MeganRoss

    Counting a formula based on a subtotal

    I'm writing a sales report that first: shows our sales reps what models they've sold to their customers second: how many customers they've sold each model third: what % of they're customers have bought each model # Report should look like this: Model_110 Model_120 Model_130...

Part and Inventory Search

Back
Top