Hello community!
I am investigating the possibility of using PowerApps to generate quotes for our business. Within this tool there will be several calculations that will need to be executed. Question is, would we be able to store all the calculations in Components and have those calculations executed in different Screens?
So one example would be I need to calculate the volume of business that we would book for the term of a contract. I would have a form where I would capture current volume, estimated increase per year, and term of the contract. With this info I would need to calculate the compound volume and have that entered into a "total volume" field. For example initial volume of 100000, with a 3% increase over a 5 year contract.
If I was to put that formula use to calculate in a component, would that work? Would I be able to have the "total volume" field default to the formula in the component? Would I be able to reference the proper fields needed for the formula, that would exist on other screens?
I have been testing the formula within the form using;
With
( {p:TextInput2, //Initial volume
r: TextInput6, //% increase
t: TextInput16}, // Term
p*(1+r)^(t)
)
This kinda works although getting the field to trigger the calculation has been inconsistent for some reason. In any case would this logic work in a component?
Any advice would be apreciated!
Thanks
Mark
