Unanswered

Calculated Column to calculate by Currency field in another table

(0) Share

Report

Posted on by Priscilla804

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.

(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 ?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Priscilla804 14 on at

Like (0)

Report

Hi Chris,

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

The result was as below:

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.

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.

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

Was this reply helpful? Yes No
Priscilla804 14 on at

Like (0)

Report

Any ideas please ?

Was this reply helpful? Yes No
steeevid 323 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Priscilla804 14 on at

Like (0)

Report

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.

Was this reply helpful? Yes No