How to apply multiplication ( * operator) to the values in a single column of power apps gallery

Like (1) Share

Report

Posted on 16 Mar 2025 13:58:07 by pdiddi123

In order to get desired output (90.08552), I explicitly used multiplication operator '*' between values. (Example: 98 *98*93.8 /10000 = 90.08552).

My question is, can we use * operator similar to sum function to multiply values in a single column? or Is there any alternative to loop through the values to apply * operator?

Here is the example of a 'Sum' function in power apps: Sum(Gallery.AllItems, columnname);

I tried following to get above value for top 3 rows. but the rows are dynamic.

Set(varAFTT, ForAll(GalleryLRR01.AllItems,If(Value(ThisRecord.txtAFTT.Text)>0, Value(ThisRecord.txtAFTT.Text) )) );
Set(varAFTTMul,(Index(varAFTT,1).Value*Index(varAFTT,2).Value*Index(varAFTT,3).Value)/10000);

Please help....

Categories:

Power Platform Build Tools

All responses (1)

Answers (0)

Suggested answer

HaiVuVIE 23 on 16 Mar 2025 at 17:35:26

Like (0)

Report

How to apply multiplication ( * operator) to the values in a single column of power apps gallery

Hi there, you can use the sum function to sum all value in a column of a table.
For example: if you have table like this:
ClearCollect(colDemo,[{firstcol:1,secondcol:2},{firstcol:1,secondcol:2},{firstcol:1,secondcol:2}])
you can use this function to get the total value of the firstcol Sum(colDemo,firstcol).
Have a good day!