Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Model driven app calculation

Posted on by 142

I want to add accural qty month vise  per employee . Suppose i have accural qty for emp 1 is 5 and emp 2 is -7 and -15 so accural will be calculate based on employee.

For 1 employee accural will be 5 and for 2 employee acurral will be -22 .

var accural = 0;

accural = accural+am_accural;

First i fetch employee master table -- all employee fetch

Second fetch employee accural table -- filter - emp and  period from and  period to 

but it calculate all accural qty employee filter is not working

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Model driven app calculation

    Hi,

    If possible please share the source code to help you better.

  • Sumedha Profile Picture
    Sumedha 142 on at
    RE: Model driven app calculation

    On button click on Period Line Firstly I fetch all employee in employee master table and then fetch(retrieve multiple) employee accural table -- filter use in employee accural table is employee id, period from , period to .

    On Unpaid button click i have to calculate accural qty based on employee

    for ex. accural qty is EMP1 = 3 , 7

    EMP 2 = 5

    so calculation for emp 1 is 10 and emp2 is 5

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Model driven app calculation

    Hi Sumedha,

    Can you please share the approach you are using to retrieve the employee accrual table where the employee filter is not working?

    If I answer your question then please mark it as verified.

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans