I have a gallery that each row calculates a total amount. underneath the gallery i have a label that sums the total of all the total amounts in the gallery using allitems but it is not displaying on my end result label.
Trying to have the results in the Net Amount: "$"& Text(Sum(galEditRequestItems.AllItems, lblCPREditItemAmount), "[$-en-US]#,##0.00")
I figured out my issue. I made a new text label inside the non nested gallery and it just worked as originally entered. It does not work outside of the gallery.
I tried it and still only shows $
I tried all 3 of those and no luck
Hi @scottmcnitt,
I think you should refer to the lblCPREditItemAmount.Text, modify your formula as below:
"$"& Text(Sum(galEditRequestItems.AllItems, lblCPREditItemAmount.Text), "[$-en-US]#,##0.00")
You could find that I refer to Title39.Text from my Gallery29.
Try (I don't know which kind of text label this is):
Value(lblCPREditItemAmount)
Or
Value(lblCPREditItemAmount.text)
Or
Value(lblCPREditItemAmount.value)