web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Working with Enums in ...
Finance forum

Working with Enums in Formula Designer for Electronic Reporting

(0) ShareShare
ReportReport
Posted on by lightbulb 45

Hi All,

I'm aware that ER Formula Designer is unable to implicitly return the value of Enums. However, I need to return values based on a data model enumeration. How do I format an enum in CASE statement to achieve the following if the model field is called model.IsConfidential (contains 2 indexes of 'N' and 'Y'):


CASE(model.IsConfidential, ?????, "Y", "N")

Thanks for the help!

Categories:
Financial Management
Development / Customization / SDK
  • Mea_ Profile Picture
    Mea_ 60,286 on at

    Check this thread https://community.dynamics.com/365/financeandoperations/f/765/t/319051

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    In the case expression you have to map the elements from your different sources.

    A simplified example can be found here: docs.microsoft.com/.../general-electronic-reporting-formula-designer

    The important thing missing is that you refer to the individual enum values that you have specified in your model.

    Best regards,

    Ludwig

  • kuljule Profile Picture
    kuljule 5 on at

    I know this question is from 2 years ago, but I think I stumbled on a solution. My model enum is called "IsProForma" and it has either "No" or "Yes." When I converted the field to TEXT, it printed "EREnumDataSourceHandler#NoYes#No." This allowed me to evaluate the enum with the text function. IF(TEXT(IsProForma)="EREnumDataSourceHandler#NoYes#No","No","Yes").

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans