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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Weekly Sales Key In li...
Power Apps
Unanswered

Weekly Sales Key In like Excel

(0) ShareShare
ReportReport
Posted on by
Hi All,
I have different Products like Product1,Product2 and so on.
Want to enter no of Sales for each day from Sunday to Saturday.
Last cell sum of all values for that week.
How to achieve this?
Thanks in advance.j
I have the same question (0)
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at
    Re: Weekly Sales Key In like Excel

    Hi @ssl790 , 

     

    For creating such an app with CDS, you have to create an entity first with attributes (Product Name, Monday - Sunday hours, total)
    While creating the total field, make it as a calculated field, and inside the formula add all the different attributes from Monday to Sunday.
     
    MicrosoftTeams-image (52).png
    Now, when you will enter data in the Monday-Sunday columns, data will get autopopulated for Total.
    I tried to build a powerapp, directly selected my newly created entity as data source from the New App menu item.
    MicrosoftTeams-image (53).png

     

     
    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard