Calculating VAT and Total amount from one input

(0) Share

Report

Posted on by drossi

134

Hello,

I have a SharePoint List and used that as my form for this page.

Most of it is View only apart from DataCard box 'SubTotal'.

What I want to happen is when user inputs a figure in 'SubTotal' box (for example €100), I want Datacard box 'VATAmount' to populate with the VAT Amount according to this calculation 'SubTotal' x 'VATRatetoApply'. I currently get an error, I think it is because 'VATRatetoApply' is a Choice within my SharePoint list. I've tried updating the 'VATRatetoApply' default to a .Value in my formula but does not work.

So in this case, I've already got the 'Total' to populate with 'SubTotal' + 'VAT Amount'.

So in an ideal world, I would input 100 in SubTotal box, then VAT Amount would populate with 13.50 and Total Box would populate with 113.50.

Screenshot 2021-03-25 at 20.29.47.png

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @drossi ,

Could you tell me:
What is your final calculation goal? ( Total = Sub Total+ Vat Amount Or Total = Sub Total + Sub Total * VatRateToApply)
What is your formula? What is its error message?
What are the data types of the 4 columns?
What are the controls used in 4 datacards?

Best Regards,
Wearsky
drossi 134 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, @v-xiaochen-msft

1. It would be 'Total = Sub Total+ Vat Amount'
2. Error: Invalid Argument Type. Expecting one of the following: Number, Text, Boolean.
3. SubTotal, VatAmount and Total are currency. Vat Type is a Choice that lets user select either 0.00 or 13.5
4. Not sure in the ask here, sorry.
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @drossi ,

Please try to use this formula on Default property of Vat Amount datacard.
DataCardValue22*DataCardValue32.Selected.Value

If it still does not work correctly, please tell me what control DataCardValue32 is.
Is it a combo box control ? Or a textinput control?

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
drossi 134 on at

Like
a
(0)

Report
Copy link

Link copied!

Ah thanks so much. That worked a treat!