Hi folks,
first of all I apologise for my broken English.
I need to calculate a percentage between a number stored in a variable (which is the max value - i.e. 100) and a number that is stored in an excel interface asset.
unfortunately the math & logic converter doesn’t allow to use dynamic data.
I’ve tried to use the linear converted as explained in this article (https://support.intuiface.com/hc/en-us/articles/360007179992-Interface-Asset-Linear-Converter#convert-a-value-into-a-percentage) but the result is not correct.I would utterly appreciate your help.
thanks in advance. all the best.
Andy
Hi Andera @a.finizio and welcome to the Intuiface community.
Since you are already using an Excel file, you could use either a separate sheet or additional columns into your current one to compute that percentage using a basic formula.
Something like this:
Use an Update Cell action to enter your current value.
Then, to retrieve the result of that formula cell, use a Set Text action and bind the parameter to that formula.
See more details in this How to use Excel Formulas article.
Let us know if that answers your need.
Seb
many thanks. it worked perfectly
1 Like