One of my fields in dataverse table cannot be used as a reference in a calculated column

(0) Share

Report

Posted on by Power5

Hello,

I have a field in my table that doesn't allow me to use when trying to create a calculated column. It doesn't even show up in my list of fields to apply to a formula.

Categories:

I have the same question (0)

All responses (5)

Answers (1)

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

Re: One of my fields in dataverse table cannot be used as a reference in a calculated column

which type is this field?

can you post a screenshot?

Was this reply helpful? Yes No
Power5 on at

Like (0)

Report

Re: One of my fields in dataverse table cannot be used as a reference in a calculated column

Was this reply helpful? Yes No
Verified answer

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

Re: One of my fields in dataverse table cannot be used as a reference in a calculated column

the reason should be the type Float, I didn't find a documentation link but float fields cannot be used in calculated columns. Do you need exactly a float for this field? because if you can create a decimal, it should be possible to be used inside a calculated column.

Was this reply helpful? Yes No
Power5 on at

Like (0)

Report

Re: One of my fields in dataverse table cannot be used as a reference in a calculated column

I can't change the data type now though. Is there a way to edit it inside of the dataverse?

Was this reply helpful? Yes No
Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

Re: One of my fields in dataverse table cannot be used as a reference in a calculated column

you can't change the data type, you will need to create a new field (and if you want to use the same name you will need to delete it first, keep in mind that when you delete a field, all the values inside the records regarding that field will be deleted as well)

Was this reply helpful? Yes No