Group by sum label

(0) Share

Report

Posted on by dursunzeeee

109

Hello, I want to collect the products I have sold on different dates by grouping them in a single line for micros Kod

My Gallery cod is here

With({_data: Filter(konsol; CUSTOM_GURUP = Dropdown17_8.Selected.Result &&
Tarih >=dpfrom.SelectedDate && Tarih <=dpto.SelectedDate
 )};
 With({_innerData:
 AddColumns(_data;
 "_sum"; Sum(_data; SALES);
 "_pop"; Average(_data; SALES);
 "_cost"; COSTPRICE / NET_SALES_PRICE;
 "total_sales"; SALES*NET_SALES_PRICE
 )
 };
 AddColumns(_innerData;
 "_costAvg"; Average(_innerData; _cost))))

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,738 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @dursunzeeee ,

The below is free-typed (so watch commas/brackets etc), but the below is the structure you need for nested With() statements.

With( { _innerData: With( { _data: Filter( konsol; CUSTOM_GURUP = Dropdown17_8.Selected.Result && Tarih >=dpfrom.SelectedDate && Tarih <=dpto.SelectedDate ) }; AddColumns( _data; "_sum"; Sum(_data; SALES); "_pop"; Average(_data; SALES); "_cost"; COSTPRICE / NET_SALES_PRICE; "total_sales"; SALES*NET_SALES_PRICE ) ) }, AddColumns( _innerData; "_costAvg"; Average(_innerData; _cost) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
dursunzeeee 109 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thank you very much for your help, but I've been trying to learn powerapps for 10 more days.
When adding the code you shared with the gallery, it failed. 😞
WarrenBelz 156,738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@dursunzeeee ,

That does not help me - I was using your values which may be invalid. I need to know what is invalid and the error message.

Also if you are new to Power Apps, why are you attempting such a complex With() statement?