Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Business Central forum

Displaying data in cues

(0) ShareShare
ReportReport
Posted on by 305

Hi

I want to display a percentage value on a cue in my extension on a role center page. The numbers to calculate the percentage are to be taken from two different tables(1. Employee table; 2. A new custom table in the extension). Is there a way to do such calculation? Please help.

Thanks

Categories:
  • Peter Zentner Profile Picture
    390 on at
    RE: Displaying data in cues

    You have the first field that should give you the first part of the information. Now you can create the other fields that will give you the remaining bits of information you require. Them you can display those different fields or calculate the final number from the individual fields and then display that.

    We can assist you with questions on wht your code doesnt work, but we are not a code writing service nor are we a replacement for formal training, classes, ronin person mentoring.

  • khudeja Profile Picture
    305 on at
    RE: Displaying data in cues

    Hi

    Thanks for replying. I am new to business central and al development. I am not able to comprehend the existing implementation. However, I am attaching my code snippet below of the cue table fields where I have to do the calculation. Please suggest whatever change is required in the code form.

    field(2; "Previous Month - Global"; Integer)

           {

               FieldClass = FlowField;

               CalcFormula = count ("Employee" where ("Office Location" = Filter ('GLOBAL')));

           }

    Requirement is to calculate number of employees with office location= Global, leaving the org to the total number of active employees in the org in the last month. Active status of employees is stored in the Employee table and number of left employees is in custom table named Employment.

    Please suggest.

    Thanks again

  • Peter Zentner Profile Picture
    390 on at
    RE: Displaying data in cues

    I would suggest that you find one of the existing implemenations and model your own like it. You can easily look at page 9060 "SO Processor Acitvities" that uses the "Sales Cue" to display various information.

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 > Business Central forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans