Help with a formula to sum collect values

[resteve]

Hello,

I create a collection from excel Datasource with the formula: ClearCollect(GroupbyConcept; GroupBy(Tabla1; "Concepto"; "total")) 

But I don't know how to  Sum the prices by concept, por example:

Autopista: 64 €

Dieta: 117,54

Excel DataSource:

 

[Meneghino · Accepted solution]

Hi @resteve, please try this. (Please note that you probably have to use ; instead of ,)

AddColumns(GroupByConcept, "SumByConcept", Sum(total, Precio))

You could even do this

ClearCollect(GroupbyConcept, AddColumns(GroupBy(Tabla1, "Concepto", "total"), "SumByConcept", Sum(total, Precio)))

Please let me know how you get on.

[resteve]

Perfect, it works!

Then I need two formulas and two different buttons?

ClearCollect(GroupbyConcept; GroupBy(Tabla1; "Concepto"; "total"))

ClearCollect(GroupbyConcept;AddColumns(GroupBy(Tabla1;"Concepto";"total");"SumByConcept"; Sum(total; Precio)))

I add a chart but the legend is the same than chart, Can I change to concepto?. Thank you!

[resteve]

Sorry, first paragraph or question of the previous post is already solved, I can have several actions in one formula with PowerApps chaining operator: ;; (double semi-colon) but only it's necessary the second action. Thank you!

[Meneghino]

Hi @resteve

Yes, try changing the labels or series to Concepto, see below...

[resteve]

Hi,

I attach some screenshots because I've changed the labels and series but it doesn't work.

[Meneghino · Accepted solution]

Hi @resteve

I have found the solution.  The key is in your third screenshot.  You need to change the Items property from PieChart1.SeriesLabels to GroupByConcept and then the Value to Concepto.

Please let me know how you get on.

[resteve]

Done . Thank you so much!. This community is very helpful!