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

All responses (3)

Answers (0)

Drew Poggemann 9,273 on at

Like (1)

Report

Re: text Calculation field concatenating numbers

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.

AhmedSalih

6,678 on at

Like (1)

Report

text Calculation field concatenating numbers

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

Gowri Halan 262 on at

Like (0)

Report

Re: text Calculation field concatenating numbers

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