Hi all
I struggle with calculations in PowerApps. In excel I am able to create the form, and get the desired output, but I want to create an app letting user make those calculations without having to access excel. What I have is:
SharePoint list with my values to calculate with, the title is the name of the products, and then I have 4 columns with valuse, RangeMin, RangeMax, ValidationMin, ValidationMax.
Besides those values that do not change that often (but could be updated by an admin), I have empty fields where the user inputs some numbers. In the end I have a Score field that displays the calculation, a mix of the user input numbers and the values from SharePoint.
In Excel I can do a formula and pick and choose calues to calculate, but how can I do it in PowerApps, that is, how can I say (Title3.ValidationMax - Title3.Validation.Min) / (Title3.RangeMax-Title3.RangeMin).
I am unaware how to exactly point/refer the different values. I could maybe create a lot of variables, and let the Admin update those in the PowerApp and get rid of the SharePoint list, but is this a better approach then using the SharePoint list?