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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calculated Column to c...
Power Apps
Unanswered

Calculated Column to calculate by Currency field in another table

(0) ShareShare
ReportReport
Posted on by 14

Hi, 

I wonder if you can help me with my issue.

Scenario:
I have 2 tables Jobs and Projects. The relationship between them is N:1 (many jobs to 1 project) through a column called Project code in the Jobs table. This field lets the user select the project code.
I have a Column in the Projects table called "Project Rate", which is of type Currency.
In the Jobs table, I have a column called "Number of Hours", which is of type Whole Number

What I would like to achieve:
I would like to create a calculated column that calculates the Cost of that job = Number of hours * Rate.

I tried creating a calculated field of type currency with the following condition, however the result is blank.

 

Pri_0-1684766369089.png

(Amount = Name of Column, NumberOfHours = Whole Number column, CostCentreCode = Name of relationship field where it lets user search for Project Number, Hourly Rate = the Project Rate)

 

I then tried to create a simple column in the Jobs table, to 'import' the Project Rate, and have it in a column in the Jobs table, but had the same result, blank

 

Do you have any what the issue might be please ?

I have the same question (0)
  • ChrisPiasecki Profile Picture
    6,422 Most Valuable Professional on at

    Hi @Pri,

     

    I suggest adding NumberOfHours contains data to your condition. If it's not populated, your calculation will be blank. 

     

    To test that the condition is working correctly, can you add an else condition to set the value to 0 and see the behavior?

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

  • Priscilla804 Profile Picture
    14 on at

    Hi Chris,

    Thanks for your reply. I have amended the condition as suggested 

    Pri_0-1684821685795.png

     

    The result was as below: 

     

    Pri_1-1684821702972.png

     

    It seems that the condition is working but the actual sum is not.

     

    I have created an additional calculated column in the Jobs table that just shows the Project Rate. 

     

    Pri_2-1684821899213.png

    The result is also Blank. so the data in the field Hourly Rate in the Project table is not getting pulled in the Jobs table. 

     

    Pri_3-1684822020771.png

     

    Any Idea why this is happening and what I'm doing wrong please ?

  • Priscilla804 Profile Picture
    14 on at

    Any ideas please ?

  • steeevid Profile Picture
    323 Super User 2024 Season 1 on at

    Just use power automate flow to calculate sum manually, roll up field is a complete bullshi

  • Priscilla804 Profile Picture
    14 on at

    Unfortunately Power Automate is not an option in this case as it requires an extra license, which the clients doesn't want to opt for.

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 802 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 332 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 273

Last 30 days Overall leaderboard