I have a calculated field which has a condition that if a value field has more than zero value then it will mark as 'available' else 'x'. I'm using the below formula:
IF SUM([Pivot Field Values]) > 1 THEN 'Available' ELSE 'x' END
Now, I have this table below:
What I would like to achieve is to count the 'Available' as I will be using this as a BAN. Is there anyway I can achieve this? By counting how many available and display it as a BAN?
In this case, I would like to get the number 11 since they have available 'string' in them.
By the way, may source data was pivoted.
Please see attached workbook.
Hi
you noted you wanted to use the value as a ban so I converted your formula to an LOD
and then use and other LOD to count them up
in the detail it would look like this include Task in Context
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
