Please let me know if I have not done a good job of explaining the scenario? Also the reason for me not including the actual dashboard is because of sensitivity of data.
Hi Harish, are you able to upload a packaged workbook to have a look at?
One thing that might simplify things is that you not need to use '= true' for a boolean field in an if statement, so [v_FY?] would be the same as [v_FY?]=TRUE and not([v_FY?] the same as [v_FY?]=FALSE.
Thank you for responding.
I used the formula as advised but still not resolved.
Actually my problem is - I have to find out if the data in the current sheet has all 12 months of data (FY) if yes then [CY Run Rate] else [CY].
I tried COUNTD([Month]) but got error "cannot mix aggregate and non-aggregate in if".
if you can help me how to use count the if function or a workaround to achieve the same would be really helpful.
SAMPLE WORKBOOK ATTACHED
Case sample.twb 349.2 KB