Skip to main content

Hi, I have to calculate totals for currency fields in a workflow.  The form is by default set / meaning each field that needs to be added initially is set to 0.00 as default in the list and set as currency. Yet when on the form two things are apparent.  If you ‘tab’ to the next entry for a currency to add, the whole of that next element is colored blue and written over as expected.  BUT, If I want to skip a field and add to another the cursor present to the LEFT of the 0.00 and then becomes say 8,340.00  when it should only be only 834.00.   The 0.00 isn’t going away when clicking into that area. The numbers persist / stay to the left of the 0.00 and the total then become completely wrong to add. 

  1. List definition for one of the adding elements, they are all same

            

  1. On the form looks fine initially as expected
    1. But then what I want in that field Materials just 834.00 yet I end up with this, what’s up with that is the question ?  
      1. Form element definition on the form itself

         

Hi @LandsEnd,

This has been posted in the Nintex Automation Cloud section of the forum, but it looks like you are using Nintex for O365. Is that correct?
You can try removing the default setting from the SharePoint column and then set the defaults using the control settings and see if that resolves your issue.

Hi, Thanks for the feedback, been off few days.  The workflow is NAC. The form o365. they work together.  I’ve found my solution. The initial issue was defining ‘currency’ for things to add. When the form opened set like that the cursor was to the left of the 0.00 set as default in list for that item as currency. Problem was clicking onto that area, not tabbing to it, the cursor was to the left of the 0.00 and what number you entered went to the left of that 0.00.

What did work was to set the list items to calculate (done by NAC) to ‘number’, and then set it to ‘automate’ and then default value to 0.  When you introduce that onto the form what’s interesting is looking at the properties for that new form element will show as ‘decimal’. 

So what worked

  • In the list define like this
    • Number
    • Automate
    • Default value 0
  • When putting that element onto the form expect to see in that elements ‘definition (just click on it to see its properties) you’’ll see its defined as a decimal. Go figure. 
  • that said when you launch the form the 0 shows (defulat value) yet is overwritten by whatever you put in that cell.  And, when you move off that item / element too by default then presents two digit to right of decimal point.  
  1. SharePoint List item definition for a field to include in a calculation

          

       

  1. Introduce it onto the form and see that it in details now shows as a decimal.  Also, appears the default in the list definition comes across with two digits to the right of the decimal point. NOTE: at the top right it says number but in the definition it is represented as a decimal.  Go figure.

                 

 

 

  1. In NAC, do your calcs / save / publish 

                     

 

  1. And get your total w/o the hassle of dealing with the cursor to the left of the entry of a something to add to a cell if defined as currency. In this case total should be and is 6.

                  

 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings