I am testing a form and trying to add calculated fields. As an example I have a Ordered field and a Unit Cost field.
I built a calculated value field with the formula Ordered*Unit Cost and I can get it to calculate.
What am I doing wrong?
You say 'and I can get it to calculate'.
Is it 'can' or 'cannot'?
Is it for a new item?
Do you have the same behaviour for an existing item?
Are you picking the Item property in your formula ?
First of all, put a name to you field ("Ordered" and "Cost" for example).
Double-click on the calculate field to open the 'Control Settings' popup and at the right of the formula input field, clik on the button "f(x)",
In the new popup, in the Named Controls tab, double click to select the "Ordered" control, add the " * " in the Formula field and double-click in the "Cost" control and OK to close the 'Formula builder' and Save, done.
Please check the type of columns you are using.
I've got this working with both Ordered and Unit Cost as Numbers, if you have Unit Cost as Currency it throws an error.
Thank you everyone. I am new to Nintex and it took me a minute but I figured it all out. I have all of my formulas working now.
It is so great to have this kind of support.
As I move through my projects I am going to start using more complex formulas and will definitely reach out to you very soon.
Sent from Outlook<http://aka.ms/Ox5hz3>
Hi, Antony Weaver, if there's a "correct answer" in this thread, can you please select it? It's helpful for people who are searching for correct answers. Thanks!
Your community manager
Retrieving data ...