Show percentage format number from the SUM of various fields

(0) Share

Report

Posted on by esjimenezp

485

Hi community,

I have the next formula...

Text(
 (txt_TotalUnits1_N_OXN / Sum(
 txt_TotalUnits1_N_OXN,
 txt_TotalUnits2_P_OXN,
 txt_TotalUnits3_K_OXN,
 txt_TotalUnits4_S_OXN,
 txt_TotalUnits5_Ca_OXN,
 txt_TotalUnits6_Fe_OXN,
 txt_TotalUnits7_Mg_OXN,
 txt_TotalUnits8_Mn_OXN,
 txt_TotalUnits9_Zn_OXN, "#%"
 ))
)

And I would like to convert to a percentage format like the next picture from Excel, any suggestion that would be great, thanks in

advance.

Kind regards 👋

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!

Use round() and multiply the value of all your sum by 100

Was this reply helpful? Yes No
esjimenezp 485 on at

Like (0)

Report
Copy link

Link copied!
Thanks @TheRobRush for your comments, can you help me to understand this one
Round(Value(txt_TotalUnits1_N_OXN.Text) / Sum(Value(txt_TotalUnits1_N_OXN.Text), Value(txt_TotalUnits2_P_OXN.Text), Value(txt_TotalUnits3_K_OXN.Text), Value(txt_TotalUnits4_S_OXN.Text), Value(txt_TotalUnits5_Ca_OXN.Text), Value(txt_TotalUnits6_Fe_OXN.Text), Value(txt_TotalUnits7_Mg_OXN.Text), Value(txt_TotalUnits8_Mn_OXN.Text), Value(txt_TotalUnits9_Zn_OXN.Text) * 100, "#%"))
it show me the next error
Thanks again for your time 👋

Kind regards!!

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!
typing from my phone so let me know if theres an error but should be more like

Round( Sum( txt_TotalUnits1_N_OXN / Sum( txt_TotalUnits1_N_OXN, txt_TotalUnits2_P_OXN, txt_TotalUnits3_K_OXN, txt_TotalUnits4_S_OXN, txt_TotalUnits5_Ca_OXN, txt_TotalUnits6_Fe_OXN, txt_TotalUnits7_Mg_OXN, txt_TotalUnits8_Mn_OXN, txt_TotalUnits9_Zn_OXN) *100 ),2)

then just concatenate or whatever you prefer to throw a % on the end

Was this reply helpful? Yes No