lookup tax rate and getting the total

(0) Share

Report

Posted on by ntt56k4

219

Hi all,

I am using the formula below to look up the tax rate based on the zip from another datafield but I am having a hard time adding it to the subtotal datafield (DataCardValue16_1) in order to get the total.

If(Form1.Mode=FormMode.New,LookUp(TaxRates,ZipCode=DataCardValue22_1.Text,EstimatedCombinedRate),Parent.Default)

Anyone know why?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ntt56k4 :

Do you want to get the sum of the EstimatedCombinedRate fields of all records in the table "TaxRates" whose ZipCode values are equal to DataCardValue22_1.Text?

If so ,the formula should be:

If( Form1.Mode=FormMode.New, Sum Filter( TaxRates, ZipCode=DataCardValue22_1.Text), EstimatedCombinedRate), Parent.Default )

Best Regards,

Bof

Was this reply helpful? Yes No
ntt56k4 219 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately no. I have two data fields, one is the subtotal and the other one is for tax amount. I used the formula above to look up the tax rate but I want to take it further by multiplying the tax rate to the subtotal field so I can get the total of the tax amount.

Also, I used the formula below to generate the tax rates but the data field is showing decimal value rather than percentage. I can't seem to come up with a correct formula to display percentage instead.

LookUp(TaxRates,ZipCode=DataCardValue22_1.Text,EstimatedCombinedRate)

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ntt56k4 :

Do you want to show "10.2%" instead of "0.102"?

If so,please try:

LookUp(TaxRates,ZipCode=DataCardValue22_1.Text,EstimatedCombinedRate)*100 & "%"

Best Regards,

Bof

Was this reply helpful? Yes No
ntt56k4 219 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks that works

Was this reply helpful? Yes No