Video blog: Amount Calculation Based on Dynamic Field

Amount Calculation Based on Dynamic Field Input.

High level resolution steps

I have added “Amount” and “Discount percentage” Textinput and Label for showing Calculated Value.

Detailed resolution steps

Step 1: Added all the text input and label for showing calculation.

Step 2: Now in Calculated Value Label Text property adding the formula for calculating discount percentage.

If( 
     IsNumeric(TextInput_percentage.Text), 
     TextInput_amount.Text * (1 - Value(TextInput_percentage.Text) / 100) 
)
    

Above “TextInput_percentage” is Discount Percentage Field name

And “TextInput_amount” is Discount Amount Field name

And in next Calculated Value Label Text property adding the formula for calculating discount amount.

If( 
    IsNumeric(TextInput_discamount.Text), 
    TextInput_amount2.Text - Value(TextInput_discamount.Text) 
)
    

Above “TextInput_discamount” is Discount Amount Field name

And “TextInput_amount2” is Discount Amount Field name

Output

When I enter the amount, it will calculate value based on what discount percent we enter same when I enter amount it will calculate value based on discount amount.

Saumya Anilkumar

Technical Consultant – Interested in creating stunning Power BI dashboards and interest towards Power Apps applications.