Changes between Version 1 and Version 2 of Ticket #11305, comment 12


Ignore:
Timestamp:
09/08/11 19:27:56 (3 years ago)
Author:
crayz_train
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #11305, comment 12

    v1 v2  
    11I need the equivalent of sumifs (http://office.microsoft.com/en-us/excel-help/sumifs-function-HA010047504.aspx?CTT=3) and countifs (http://office.microsoft.com/en-us/excel-help/countifs-function-HA010047494.aspx) to replace a report that is currently baked into an excel spreadsheet somewhere.
    22
    3 In a nutshell, we have orders which have a quantity of items, a total amount for the order, tax amount, and are related to a specific customer name. I need to output something like this:[[BR]]
     3Over-simplified, we have orders which have a quantity of items, a total amount for the order, tax amount, and are related to a specific customer name. I need to output something like this:[[BR]]
    44Customer, Total Items (per customer), Total Orders (per customer), Total Amount (per customer), Total Tax (per customer)[[BR]]
    55UserA,6,3,$50,$5[[BR]]
Back to Top