Calculated Field with a Yes/No Toggle Switch

(0) Share

Report

Posted on by billf24

158

I have a temporary Collection where I want to calculate the result from 2 fields.

This first field has a numeric value. The second filed is a Toggle (Dataverse Table is Yes/No).

If the Toggle is True(Yes), then the first field is multiplied by.75, otherwise it is just the first field.

This is what I have tried so far and am getting "This formula uses scope, which is not presently supported for evaluation. | Data type:number

If(ThisItem.LinePerDiemRate <> 0 && ThisItem.LineTravelDay = true, ThisItem.LinePerDiemRate * .75), ThisItem.LinePerDiemRate

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @billf24 ,

Please make the following change in your code:
If( ThisItem.LinePerDiemRate <> 0 && ThisItem.LineTravelDay = true, Value(ThisItem.LinePerDiemRate) * 0.75, Value(ThisItem.LinePerDiemRate) )

Hope this helps

Was this reply helpful? Yes No
billf24 158 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the reply. I am getting a 0 when I add the formula, but when running it and setting the toggle to true, the value does not change from 0.
Anything else to look at?

Also getting "This formula uses scope, which is not presently supported for evaluation."

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @billf24 ,

I missed the value on the top.
Value function converts text to numeric data for evaluation
If( Value(ThisItem.LinePerDiemRate) <> 0 && ThisItem.LineTravelDay = true, Value(ThisItem.LinePerDiemRate) * 0.75, Value(ThisItem.LinePerDiemRate) )

This will help

Was this reply helpful? Yes No
billf24 158 on at

Like (0)

Report
Copy link

Link copied!

Thanks for that but still not working.. Should these fields be text instead of value?

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @billf24 ,

Where are you using the formula?
can you send the screenshot of the location where you are trying to use this?
Since syntax will change depending on usage

Was this reply helpful? Yes No
billf24 158 on at

Like (0)

Report
Copy link

Link copied!

The Column Per Diem Rate is LinePerDiemRate, Travel Day is LineTravelDay and the Reimbursement is LineReimbursement. This is a Collection not currently being sent to the Dataverse Table. This is being designed as a repeating row.

Was this reply helpful? Yes No