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
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.
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
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.