Hi,
I have collated multiple tables into one overall table which is named OverallTable.
The OverallTable has multiple fields:
The Overall Table has about 40 records.
I am trying to get a multiplication of all the rows in RF i.e. 1 x 1 x 1.1822 x 1.100 x 0.7 x 1 x 0.4...
but I understand that PowerApps has no such function.
I am trying to follow the suggestion below:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Calculate-Product-Multiply-all-numbers-in-a-collection/td-p/559301
and ended up with
ClearCollect(NumColTest,{total:1});
ForAll(OverallTable,Patch(NumColTest,First(NumColTest),{total:First(NumColTest).total*CountRows(OverallTable)}));
However, I want to have the product of the column RF, so so I tweak it:
ForAll(OverallTable.RF,Patch(NumColTest,First(NumColTest),{total:First(NumColTest).total*CountRows(OverallTable)}));
A first look at NumColTest doesn't seem right, assuming it is the product of the RFs.
Below is when I force the number of records to be 2:
ForAll(OverallTable.RF,Patch(NumColTest,First(NumColTest),{total:First(NumColTest).total*2}));
Wondering if anybody has any ideas? Thank you.
