cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Total not showing right for one of the cards.

Hi

 

In a powerapp, I have two repeating sections as below where amount is collected.

1st collection 

Capture.JPG

 

2nd collection

Capture2.JPG

 

Then I have a total expense field on the main screen which shows sum of the amounts collected from above which should be 63.11 based on above two values. 

Instead, I am seeing 63.10 returned for some reason for total expense. 

total.JPG

 

Here is the formula I am using for Total expense field: Text(Sum(ExpenseCollection, Amount)+ Sum(MileageCollecion, MileageAmount),"[$-en-US]$#,##0.00")

any reason why its not returning 63.11? please help me correct it. 

1 REPLY 1
v-siky-msft
Community Support
Community Support

@Anonymous 

That' weird, If I test 'Text(40.33 + 22.78,"[$-en-US]$#,##0.00")', it shows '$63.11' correctly.

Snipaste_2020-02-12_16-08-58.png

How did you define the Text property of the first collection summary and the second collection summary? Is there a rounding case?

Could you share the Amount values of two collections?

Sik

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,598)