Greetings to all,
in order to calculate the average of a certain item and save the result in a collection, I use the filter function to filter the relevant items in the sharepoint list tbl_CAPEX.
ClearCollect(colAllBenchmarks;Filter(tbl_CAPEX_layout; Projekttyp = myProjekttyp));;
ForAll(
Filter(tbl_CAPEX_layout; Projekttyp = myProjekttyp);
Patch(
colAllBenchmarks;
ThisRecord;
{
EP: Average(Filter(tbl_CAPEX; Nummerierung_1 = Int(ThisRecord.Nummerierung_1));EP)
}
)
)
Unfortunately, I get the same result for every entry in "EP", even though ThisRecord.Nummerierung is iterated through correctly.
I appreciate any help.
