Hi - I've tried following the solutions posted but can't get this to work. I have a series of Yes/No field types. I want to add a formula into the table that will calculate the users progress based on the number of these they've completed versus the number they should have for the type... Past posts indicate I need to use 0 and 1 for the field in the formula. The formula verifies but in a test case that should show 20% done, the formulae doesn't produce an answer. Any hints?

(CASE WHEN CAST([@field:preq1] AS BIT)=1 THEN 1 END +
CASE WHEN CAST([@field:preq2] AS BIT)=1 THEN 1 END +
CASE WHEN CAST([@field:preq3] AS BIT)=1 THEN 1 END +
CASE WHEN CAST([@field:preq4] AS BIT)=1 THEN 1 END +
CASE WHEN CAST([@field:preq5] AS BIT)=1 THEN 1 END +
CASE WHEN CAST([@field:preq6] AS BIT)=1 THEN 1 END +
CASE WHEN CAST([@field:preq7] AS BIT)=1 THEN 1 END +
CASE WHEN CAST([@field:preq8] AS BIT)=1 THEN 1 END +
CASE WHEN CAST([@field:preq9] AS BIT)=1 THEN 1 END +
CASE WHEN CAST([@field:preq10] AS BIT)=1 THEN 1 END )/ [@field:rcount]

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

## Jodie

Hi - I've tried following the solutions posted but can't get this to work. I have a series of Yes/No field types. I want to add a formula into the table that will calculate the users progress based on the number of these they've completed versus the number they should have for the type... Past posts indicate I need to use 0 and 1 for the field in the formula. The formula verifies but in a test case that should show 20% done, the formulae doesn't produce an answer. Any hints?

(CASE WHEN CAST([@field:preq1] AS BIT)=1 THEN 1 END +

CASE WHEN CAST([@field:preq2] AS BIT)=1 THEN 1 END +

CASE WHEN CAST([@field:preq3] AS BIT)=1 THEN 1 END +

CASE WHEN CAST([@field:preq4] AS BIT)=1 THEN 1 END +

CASE WHEN CAST([@field:preq5] AS BIT)=1 THEN 1 END +

CASE WHEN CAST([@field:preq6] AS BIT)=1 THEN 1 END +

CASE WHEN CAST([@field:preq7] AS BIT)=1 THEN 1 END +

CASE WHEN CAST([@field:preq8] AS BIT)=1 THEN 1 END +

CASE WHEN CAST([@field:preq9] AS BIT)=1 THEN 1 END +

CASE WHEN CAST([@field:preq10] AS BIT)=1 THEN 1 END )/ [@field:rcount]

## Link to comment

## Share on other sites

## 2 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.