Sunday, December 2, 2018

Count Transactions created for each vendor in column

1. Navigate to Lists> Search> Saved Searches> New
2. Select Transactions
3. On the Criteria select column for:

Type is any of Bill, Bill Payment, Purchase Order
Main Line is yes

4. On Results tab add the following columns:
Mark = show total
Formula (Numeric): CASE WHEN {type}='Bill' THEN 1 end
Formula (Numeric): CASE WHEN {type}='Bill Payment' THEN 1 end
Formula (Numeric): CASE WHEN {type}='Purchase Order' THEN 1 end
Summary type of each formula is Sum.
Summary type of vendor is Group.

 

 

 

No comments:

Post a Comment