Calculate $ and % fields dynamically based on change of each other

(0) Share

Report

Posted on by SarahC

I've managed to solve my issue on one side, but not dynamically based on two fields referencing each other.

What I have:

Order $ field
Estimated $ field
Estimated % field

All live in a form, all are editable.

What I need:

The estimated field should be: Estimated field = Order $ * Estimated %

BUT, the estimated field can also manually be set, in which case I need the Estimated % to change.

Estimated % = estimated $/order $*100.

So based on which estimated field is changed the other needs to dynamically change accordingly. In my attempts, I get a circular reference error.

Any help is greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

To make sure I understand. This is the formula for the Estimated $ field?

The estimated field should be: Estimated field = Order $ * Estimated %

What should the formula be for the Estimated Percent field?

Was this reply helpful? Yes No
SarahC 48 on at

Like (0)

Report
Copy link

Link copied!

@JR-BejeweledOne

Correct.

Estimated percent is the estimated $ divided by the order $ * 100

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

I think something is missing here. If both Estimated $ and Estimated % start out blank and are relying on each other, you won't get any sort of result.

For example, if there were no error, both Estimated $ and Estimated % start out as Zero. If my order $ is 150 and I multiply that by 0% (Estimated $), I get a zero value.

So is there a default percentage or number that you would be using? Otherwise I am not sure how your calculations are going to work

Was this reply helpful? Yes No
SarahC 48 on at

Like (0)

Report
Copy link

Link copied!

On initial creation in the form, the user would be setting order $ and estimates (either $ or %).

Could start with a common % if that's needed to make it work. Something like 5%.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!
Try this. For your Estimate $

OnChange Property: Set(varEstimateDollar, Value(Self.Text))

Default Property: Value(Order.Text) * varPercent

Leave the Estimate% formulas the same.

This should solve your circular error situation. It will update the variable if the field is manually changed again and everything should calculate dynamically

Was this reply helpful? Yes No