1 of 1 people found this helpful
1) RED The formula says (Current row - Previous row) / Previous row. This means if first month (previous month) of a two month comparison is null, then the formula will return null because you are dividing by null. Even if you convert it to zero using ZN(), division by zero will still return an error or blank. This is not something you can fix, except you want to change your calculation logic or ensure the first month will always have values, otherwise there will be nothing to compare.
2) PURPLE Examiner's Closing Ratio is from a different datasource. Only fields from the primary datasources can be used on the page shelf. One option you have is to use parameters instead. A parameter can be shared by all datasources in the same workbook.
3) BLUE The solution above will resolve this issue also.
Most of the sheets on the dashboard are floated. Try putting them in containers and fixing their widths or heights. Consistent decimal places for all values is ideal also. All these will help keep the sheets in place with each examiner selection.
Create parameter [Examiner Selection]. Add more examiners to the list of values if required. I added the parameter to the page shelf but it will still work if you don't add it.
Create calculated field [Selected Examiner]
[Examiner] = [Examiner Selection]
Add this as a filter to all relevant sheets and set to True.
On the dashboard, add [Examiner Selection] parameter and remove previous examiner page control and filter.
Hope this helps.
Sorry to be so late in responding. Even with a severe head cold you're wonderful instructions were easy to follow. I have implemented the Examiner Selection parameter filtering.
Thank you soooooooo much.
You are welcome. I'm glad it helped.