Hi folks, I'm totally lost and need your help.
I had my accounting team develop an excel calculator for our sales team. It works great and I wanted to make it into an app, but the formulas don't seem to tranfer properly. I'm not sure what I'm doing wrong.
I've got 10 rows and 2 columns. The 1st column is just titles for what either needs to be inputed or the title of the result calculated.
1) Contract Amount (Number Inputed)
2) Parts and Expense (Number inputed)
3) Labor Hours (Number inputed)
4) Contract Duration (Number inputed)
5) Current Monthly Rate (Number inputed)
6) New Monthly Rate (Number inputed)
7) IR Commission =B1*0.06
😎 RMR Commission =IFS(B4=0,B6-B5,B4=1,B6-B5,B4=2,2*(B6-B5),B4>=3,4*(B6-B5))
9) Total Commission =B8+B7
10) CM =IFERROR((((B2+B3*90)+B9-B1)/(B5))+11,0)
I know in PowerApps you don't put "B1" but rather the name of the text box. But I was never able to get this to work. What am I doing wrong?
Solved! Go to Solution.
(Number Inputed) - assuming this is a TextInput control in PowerApps named "TextInput1" (you can rename controls)
B1*0.06 would translate to Value(TextInput1.Text)*0.06
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
B4 = Years
B5 = Old
B6 = New
B8 = RMR
Is this right?
@bmurphy1 try this
You dont need the 'S' and i think you might need to wrap those text inputs as values. But i dont know if that is required, but that is what i would do.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications