Help! Calculated Value is blank in the SharePoint list - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Help! Calculated Value is blank in the SharePoint list

Last post 03-17-2022 08:13 AM by Hilary Stoupa. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 03-17-2022 04:29 AM

    Help! Calculated Value is blank in the SharePoint list

    Attached is my InfoPath form. The calculated values "CQ Original Order Amt", "CQ+1 Original Order Amt" ...... work in the InfoPath form but is blank in the SharePoint list. I don't know how to fix it... BTW, there is another calculated value "Impact Revenue (USD)" works well in infopath form and can be seen in sharepoint list. I have no idea what caused the different result. Thank you so much in advance!
  • 03-17-2022 07:47 AM In reply to

    Re: Help! Calculated Value is blank in the SharePoint list

    None of the fields you mention have a default value in the form - do you mean the column in SharePoint is calculated?
    Hilary Stoupa

  • 03-17-2022 08:05 AM In reply to

    Re: Help! Calculated Value is blank in the SharePoint list

    Hi Hilary, I set up the calculation formula as attached picture.
  • 03-17-2022 08:13 AM In reply to

    Re: Help! Calculated Value is blank in the SharePoint list

    I would expect this calculation to be the default on a field instead. If this is just a calculated value on the form, that won't save to the list. If, instead, you set the default value of the field, and just display the field's value in the calculated value, that should then save data correctly.
    Hilary Stoupa

Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.