Unanswered

text Calculation field concatenating numbers

(0) Share

Report

Posted on by julijazas

820

I want to create a column in dataverse that concatenatyes some decimal number columns. Decimal places is set to 2 on the columns i want to concatenate

if i perform concat(column1,Column2) i get a result of for example 25.000000000050.0000000000

for some reason it adds 10 decimal places anmd i don't see a Format option in calculated field

What is wrong here?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Gowri Halan 262 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Are you trying to concatenate two decimal number field to a text field (calculated) ? If you are using currency field then check the system setting as well.
https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/types-of-fields?view=op-9-1#BKMK_UsingTheRightTypeOfNumber

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (1)

Report

Copy link

Link copied!

Hello, @jja , Concat is treating your decimal as text values. Are you trying to sum the decimal values into new column?

You can also, try the Power Fx Formula Column: https://powerapps.microsoft.com/en-us/blog/power-fx-formula-columns-in-dataverse/

If my reply helped you, please give a 👍, & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @jja ,

I agree with @AhmedSalih to review the Power Fx Formula columns as this should accomplish your needs. Note, this is still in Public Preview so not appropriate for production environments yet.

Was this reply helpful? Yes No