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!

Register Log in
  • Congratulations Westi 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: *

  • Users: ryan7
  • Order by date
  1. ryan7

    Range Grouping

    First step would be to create calculate the difference between DoB & EnrolmentDate. Create a formula called "Age" datediff ("yyyy", {DOB}, {EnrolmentDate}) Then you can convert the age into a range with a series of IF statements. Create a formula called "Age Range": IF {@Age} < 20 THEN "<...
  2. ryan7

    creating dynamic groups from sales date

    I am currently trying to analyse a single table of data (example shown below). The table contains sales information with seller and customer ID's and we need to calculate when a seller sells more than 1 product to the same customer (at which point we assign a bonus 'sale' to the seller). To...
  3. ryan7

    Problem using SUM on group summaries

    Thank you very much once again ... worked a treat :)
  4. ryan7

    Problem using SUM on group summaries

    thanks for the great reply dk87. much appreciated :) the concept seems to work, but i think i may have made a mistake in the implementation of some part of the forumla The G2Processing forumla seems to return TRUE / FALSE result (rather than a numerical result as i would have expected). As...
  5. ryan7

    Problem using SUM on group summaries

    I have a very large amount of data, each line represents an Action by a user. I need to summarise, for each individual user the number of times they have used a particular application. The tricky part is that i can't take the total number of application usages, i need to see the number of...

Part and Inventory Search

Back
Top