Hi @AzJackson ,
Do you mean that:
1)you will select one field in each row?
2)you want to calculate the sum of the selected fields?
Could you tell me whether these fields are number type?
I assume that yes.
I suggest you use collection and gallery in your issue.
I've made a similar test for your reference:
1)set the app's OnStart:
ClearCollect(test,AddColumns(datasourcename,"selectedvalue",0))
//add a column to record the selected value
2)insert a gallery to display the table
set the gallery's Items:
test
insert multiple labels inside the gallery to display the fields
set their Text like this:
ThisItem.fieldname
3)in my test, these fields named Title1,Title2,Title3,Title4,Title5,Title6,Title7
set Title1's OnSelect:
Patch(test,ThisItem,{selectedvalue:Value(Title1.Text)})
set Title2's OnSelect:
Patch(test,ThisItem,{selectedvalue:Value(Title2.Text)})
Others are similar.
Then the selectedvalue field will be filled in the selected labels' data.
4)set Title1's Color:
If(ThisItem.selectedvalue=Value(Title1.Text),Red,Black)
set Title2's Color:
If(ThisItem.selectedvalue=Value(Title2.Text),Red,Black)
Others are similar.
Then only the selected field will be red.
5)insert a label to display the result, set the label's Text:
Sum(test,selectedvalue)
This will be the result that you want.
Best regards,
