cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DanielGT-89
Frequent Visitor

error in format of a column sum in a sharepoint list

hello, I have a problem when, I try to add a column filtered by date of the day, I am trying to add the records of a sharepoint column, but I get the sum number as if it were a much larger number

 

en la lista de sharepoint tengo estos datos

  • 3655.45
  • 5000.00

the sum would be = 8.655,45

but the label gives me the number 865545000000000

suma.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

Kindly check this post
https://powerusers.microsoft.com/t5/Building-Power-Apps/Format-issue-dollar-to-EUR/m-p/481427#M14502...

Also consider :
Wrap your formula with Text format
Text....,"[$-en-US]$#,###.00")
As:
Text(Sum(Filter('SP List','<SAME filter="" as="" the="" data="" table="">'),'Invoice),"[$-en-US]$#,###.00")</SAME>

View solution in original post

1 REPLY 1
eka24
Super User
Super User

Kindly check this post
https://powerusers.microsoft.com/t5/Building-Power-Apps/Format-issue-dollar-to-EUR/m-p/481427#M14502...

Also consider :
Wrap your formula with Text format
Text....,"[$-en-US]$#,###.00")
As:
Text(Sum(Filter('SP List','<SAME filter="" as="" the="" data="" table="">'),'Invoice),"[$-en-US]$#,###.00")</SAME>

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,920)