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.