Unanswered

Formula Column to Calculate Values of Local Choice Values

(0) Share

Report

Posted on by EricFai

Hi I have a number of Local Choice Columns that I would like to Sum up the Values of the selected choices. Is it possible to Sum up the selected choice values of multiple columns in a Formula type column?

For example, I have several columns with this type of configuration (I would like to do a Likert Scale type of selection, but could only think of doing this choice column and labelling 1 and 5 with a description, any other thoughts on how to do a Likert scale would be greatly appreciated)

When I try to create a Formula Data Type and reference the above choice columns I get the following error

Any thoughts on how I could Sum up in a calculated column, the Values of the Choice columns?

Thank you so much
Eric

Categories:

Using Apps Using Formulas

All responses (4)

Answers (0)

EricFai 40 on at

Like (0)

Report

Re: Formula Column to Calculate Values of Local Choice Values

Thanks Amik. I was originally asking how to do the sum of "Local" Choice fields within the Formula field of a Formula column. I suppose its not possible in a Formula Column.

Thanks for your help
Ami K 15,665 Super User 2024 Season 1 on at

Like (0)

Report

Re: Formula Column to Calculate Values of Local Choice Values

@EricFai - please see my earlier response. This is possible by using a Power FX formula in a Canvas App.
EricFai 40 on at

Like (0)

Report

Re: Formula Column to Calculate Values of Local Choice Values

Hi Amik, thanks for your response. I tried the formula in my Formula column but it seems Choices is not supported, and neither is AddColumns?
Ami K 15,665 Super User 2024 Season 1 on at

Like (0)

Report
Re: Formula Column to Calculate Values of Local Choice Values

@EricFai - this is possible with Power FX in a Canvas App. See example below:

Sum( AddColumns( Choices('Your Global Choice'), 'Choices Value', Value(JSON(Value)) ), 'Choices Value' )