Could someone help me troubleshoot a formula I've written for a calculated field? I have a Combined Chart and Report Datapage. The chart is a stacked bar graph, and I am using 2 calculated fields for the values on the chart. In the calculated fields, I want to create a number value for the values in two text (255) fields. So if both fields say the same value, the number in the calculated field should be 2; if only one of the fields has the correct value, the number in the calculated field should be 1.

This is what I've written:
CASE
WHEN [@field:Publications_Table_Slide_Status] = 'Requested' OR [@field:Publications_Table_Summary_Status] = 'Requested'
THEN '1'
WHEN [@field:Publications_Table_Slide_Status] = 'Requested' AND [@field:Publications_Table_Summary_Status] = 'Requested'
THEN '2'
ELSE '0'
END

The calculation shows 1 in all cases, no matter what value the fields have in them

You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

## Question

## CapNcook

Could someone help me troubleshoot a formula I've written for a calculated field? I have a Combined Chart and Report Datapage. The chart is a stacked bar graph, and I am using 2 calculated fields for the values on the chart. In the calculated fields, I want to create a number value for the values in two text (255) fields. So if both fields say the same value, the number in the calculated field should be 2; if only one of the fields has the correct value, the number in the calculated field should be 1.

This is what I've written:

CASE

WHEN [@field:Publications_Table_Slide_Status] = 'Requested' OR [@field:Publications_Table_Summary_Status] = 'Requested'

THEN '1'

WHEN [@field:Publications_Table_Slide_Status] = 'Requested' AND [@field:Publications_Table_Summary_Status] = 'Requested'

THEN '2'

ELSE '0'

END

The calculation shows 1 in all cases, no matter what value the fields have in them

## Link to comment

## Share on other sites

## 3 answers to this question

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Note:Your post will require moderator approval before it will be visible.