Formula Column - Using Sum on Text Columns

(1) Share

Report

Posted on by dcastillo1

Hello,

I’m new to formula columns and could use some help.

I have a formula column that sums up several text columns containing numbers. It works perfectly for whole integers, but the formula breaks whenever a column contains a decimal value.

Here’s my current working code:

Sum(
Value('1 Fee'),
Value('2 Fee'),
Value('3 Fee'),
Value('4 Fee')
)

Any help would be appreciated! Thanks!

Categories:

General Questions

All responses (1)

Answers (0)

Suggested answer

bscarlavai33 329 on at

Like (1)

Report

Formula Column - Using Sum on Text Columns

I found this in the documentation (https://community.powerplatform.com/forums/thread/details/?threadid=1e93cc2f-7ca8-ef11-8a69-00224828633c)

"* The Text and Value functions only work with whole numbers, where no decimal separator is involved. The decimal separator varies across locales. Since formula columns are evaluated without locale knowledge, there's no way to properly interpret or generate the decimal separator."

What if you just use Decimal() instead of Value()? You might have to use the language tag like Decimal( "123.456", "es-ES" )