Forum Discussion

MatheusRuiz's avatar
MatheusRuiz
Frequent Visitor
3 years ago

Concatenate 2 rows and sum value (summarize)

Hello, hope someone can help me on that. 

 

I have a table that shows the service contracts that subscribers pay me monthly (the price of a service can change for different customers):

 

SubscriberServicePrice
AnaPositioning50
AnaPositioning Plus60
AnaStandard30
AnaStandard Bonus40
AnaCustom20
PeterStandard24
PeterStandard Bonus32
PeterPositioning50

 

I would like to conditionally summarize: if the subscriber has positioning plus, then I would like to show only this information but with the price added (positioning + positioning plus = 110). The same for standard with standard bonus, show only "standard" with the price 30 + 40 = 70. The result would be:

 

SubscriberServicePrice
AnaPositioning Plus110
AnaStandard70
AnaCustom20
PeterStandard56
PeterPositioning50

 

Thanks in advance!

Need Help

1 Reply

  • bhelou's avatar
    bhelou
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    Hello , try the switch function and sum the balances