Use Sum with decimal number

(0) Share

Report

Posted on by Powell4

Hello i have a problem.

When I use the sum function on one of my fields the function doesn't take into account decimal numbers.

How can I make my sum function add all numbers and not only integers?

For information, the data I want to sum are stored in an excel document.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Please what formula are you using?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Powell4 34 on at

Like
a
(0)

Report
Copy link

Link copied!

I use this formula :

Sum(Filter(TEMPS;CodCollab = CollabGalerie.Selected.CodCollab;If(!ActiverBoutonDate;Quand <= DatePicker1.SelectedDate; Quand >= DatePicker2.SelectedDate));Temps)

It is used to return the total of a column in my table according to various parameters.
The problem is that the function does not take into account decimal numbers.
Powell4 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Someone can help me ?
WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Powell4 ,

What exactly are you trying to total here? You have the table name and the field name the same.

Sum( Filter( TEMPS; CodCollab = CollabGalerie.Selected.CodCollab; If( !ActiverBoutonDate; Quand <= DatePicker1.SelectedDate; Quand >= DatePicker2.SelectedDate ) );Temps )

What is the name of the Table and what is the name of the field you are trying to total. Also what is the format of the field in your table.

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.
Verified answer

Powell4 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz

Thank you for your message however I found the solution to my problem. The problem was the excel format of my column, it was not the right one.
RikarHV 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Powell4 ,

Please, can you tell me which format did you use in the excel column? I am having the same problem.

Thanks in advance!