AnsweredAssumed Answered

Help: Need Calculation for Summary of a field with a specific category...

Question asked by TimRogers_1 on Jun 20, 2017
Latest reply on Jun 20, 2017 by philmodjunk

So I have the following table of Discounts:


Discount NameDiscount CategoryDiscount Amount
Customer LoyaltyPromotional$32.50
Staff MealsPromotional$48.00
Kitchen ProblemQSA$16.00
Alumni DiscountPromotional$8.25
Dissatisfied CustomerQSA$18.50


What kind of formula will work to see the totals of the discount categories?


ex. I need to see Total Promotional = $88.75, and Total QSA = $34.50, etc....


I can do a portal for each category, filtered by each category, but that only really displays the number, I need a number I can use in further calculations.


Thank you in advance for any help on this...