Calculated field on a form, with a possible IF statement from a dropdown box.

(0) Share

Report

Posted on by Theoriginal1981

Hi all,

I have a calculated field, which I think needs some sort of IF statement, but I'm not sure how to do this. Any help is appreciated. I've attached a screen shot and tried to explain below.

I have the calculated column which adds up both 1st dose and 2nd dose to tell me the total. That bit works with no issues. Although I have a lot of .00000 after the number. (That I should be able to rectify).

So where it says under each dosage 'Available'. This is a drop-down, and when I select 'not available' I want it to not include the dosage in the calculated field.

For example, I mark 1st Dose as not available. The calculated field called 'quantity' returns a value of 2.5.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Theoriginal1981 I do not know enough about your app, but you can try applying the below to the Text property of your Label:

With( { _data: Filter( Table( { DoseValue: Value('Your First Dose Quantity Label'.Text), Availability: 'Your Dose 1 Dropdown Control'.Selected.Value }, { DoseValue: Value('Your Second Dose Quantity Label'.Text), Availability: 'Your Dose 2 DropDown Control'.Selected.Value } ), Availability = "Available" ) }, Sum( _data, DoseValue ) )

Was this reply helpful? Yes No