Loading...

Calculated field for Choice field

Title

Calculated field for Choice field

Description

Calculated field for Choice field

Please wait...

I have a list with two Choice fields – Modula and Section (checkboxes)

I’ve created Calculated filed in qListForm web part that has the following formula: <%Section%><%Module%>

As a result I see the following in the calculated field ;#Section 1;#;#Module 1;#

Is there

Cause

The expression <%FieldName%> returns the raw value of the field as it's stored in SQL database

Resolution

You can put JavaScript function that would extract the value out of these fields and then apply the calculation formula.

Defect ID

The expression <%FieldName%> returns the raw value of the field as it's stored in SQL database

Leave a Reply