Code

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


Ignore:
Timestamp:
09/08/11 17: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]]