AnsweredAssumed Answered

DEDUCTION OF ITEM FROM TOTAL BY PRIORITY

Question asked by YunusSoud on Sep 10, 2017
Latest reply on Sep 12, 2017 by philmodjunk

Please help me on creating function that will select item by priority defined and subtract from total count and continue to next item, till end of the list, and display the result of each item.

 

Example:

Company provides 3 services to the customers, cleaning ($100), Washing ($50) and Gardening ($50) per month. After providing service the customer paid $170. How to set formula (function) to show that customer paid $100 for Cleaning, $50 for Washing and $20 for Gardening, as the priority is

  1. 1. Cleaning,
  2. 2. Washing and
  3. 3. Gardening.

 

The function (formula) should deduct by priority from the Total received $170 as above.

 

Thanks.

Outcomes