cancel
Showing results for
Did you mean:
New Member

## help with gallery sum value

esta es una galera dinámica de sharepoint y solo quiero sumar toda la columna de valor [Total]

Cómo puedo hacer eso ?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

I assume Total was a number field - obviously it is not. If is it a number stored as Text with that Euro symbol in front

``````Sum(
YourGalleryName.AllItems,
"TotalEuro",
Value(
Substitute(
Total,
"\$",    //you will need the Euro symbol here
""
)
)
),
TotalEuro
)``````

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

15 REPLIES 15
Impactful Individual

Hola @ruben_vera ,
pruebe esto

``Sum(Gallery, Total)``

<u+200e> <u+200e><u+200e>Acepte esto como una solución<u+200e><u+200e> si funciona para usted. <u+200e>ión<u+2

Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the thread and so other members of the community can find it easily.
Helper V

Hi @ruben_vera ,

Puedes probar con sum( nombre de la tabla, nombre de la columna )

Super User

Try (replace with your gallery name)

``````Sum(
YourGalleryName.AllItems,
Total
)``````

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

New Member

this method din´t work

Super User

I assume Total was a number field - obviously it is not. If is it a number stored as Text with that Euro symbol in front

``````Sum(
YourGalleryName.AllItems,
"TotalEuro",
Value(
Substitute(
Total,
"\$",    //you will need the Euro symbol here
""
)
)
),
TotalEuro
)``````

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

New Member

Unsepered characters. Formula contains parentClose where error was expected

unexpected characters. Characters are used in the formula unexpectedly

New Member

Total is column from sharepoint

Super User

You are missing a comma after "Total Euro".

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

New Member

same error with , after "Total Euro"

Announcements