Web Reference: Dec 4, 2020 · A handy tip when creating expressions is to look for the (f) button - usually on the left at the bottom in the expressions dialog. This gives you access to see (and drag in) a very useful set of expressions for functions, summaries, constructs, constants etc. CASE WHEN THEN . . . [ ELSE ] END. I found this link to be helpful in learning how to do that (useful even for your use-case which is not percentages): Considerations for percentage calculations in dashboards in Cognos Analytics 11 Mar 30, 2015 · If you insist on using a CASE statement then I believe you can put parentheses around your WHEN clause and provide a result for ELSE and it should work: CASE WHEN ([Force Expired] = 'Inforce') THEN ([Policy Expiration Date] >= current_date AND [Policy Effective Date]
YouTube Excerpt: You may use a
Information Profile Overview
Cognos Analytics Case Statement - Latest Information & Updates 2026 Information & Biography
Details: $56M - $66M
Salary & Income Sources
Career Highlights & Achievements
Assets, Properties & Investments
This section covers known assets, real estate holdings, luxury vehicles, and investment portfolios. Data is compiled from public records, financial disclosures, and verified media reports.
Last Updated: April 3, 2026
Information Outlook & Future Earnings
Disclaimer: Disclaimer: Information provided here is based on publicly available data, media reports, and online sources. Actual details may vary.