Calculated Field - Multiple IF Statements Not Retaining Calculation when Form Saved | Community
Skip to main content
C
ChristineZh3
Level 2
July 9, 2024
Question

Calculated Field - Multiple IF Statements Not Retaining Calculation when Form Saved

  • July 9, 2024
  • 1 reply
  • 841 views

Hi Community,

 

Has anyone else experienced this issue – I have a custom form with a series of questions that is meant to act as a scorecard with the calculated field providing the final score. The calculated field seems to work fine when the form is being edited - it provides the total score - then as soon as I hit save, the field goes to N/A. My text mode is below – 

 

 

SUM(IF({DE:Noticeable within 5 seconds?}="Yes", 1,0),IF({DE:Adding or removing an element?}="Yes",1,0),IF({DE:Influencing Production Updates "Runway Work"}="Yes",1,0),IF({DE:Addressing a Customer Pain Point?}="Yes",4,0),IF({DE:Ties to an experience that matters most?}="Yes",3,0),IF({DE:Supports enterprise objective or OKR?}="Yes",2,0),IF({DE:Supported by Data or Previous Results?}="Yes",3,0),IF({DE:Low LOE?}="Yes",1,0))

 

 

I've tried removing the 0 from each IF statement and I also made sure that the format of my field is a Number.

 

Please see screenshots attached, thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Kurt_Jones
Community Advisor
Kurt_JonesCommunity Advisor
Community Advisor
July 9, 2024

ChristineZh2,

That is normal behavior for the calculated field.  Make sure you've checked the field to recalc your expressions so that those objects that have this calc field refresh in the background to do the calculation.  I've still at times had to do a recalc expression on an object to finally get it to render my calculated field.  Your field will stay at NA until those fields are filled out and your form "saved", it should then render.

If my response answered your question, please mark it answered, so others can find the answer
C
ChristineZh3Author
Level 2
July 10, 2024

Hi Kurt,

 

I tried recalculating the expression numerous times but it always stays as NA. Not sure what you mean by "Make sure you've checked the field to recalc your expressions so that those objects that have this calc field refresh in the background to do the calculation." Could you clarify? Thank you for your help!

Kurt_Jones
Community Advisor
Kurt_JonesCommunity Advisor
Community Advisor
July 10, 2024

ChristineZh2,

When you are in your form, looking at the calc field you'll see something on the left like below, clicking the "apply to existing calculations" 

However, I think I understand better, you're looking at your calc field when doing a Preview in the form and you see NA, that will be normal behavior as you don't have option to submit/save for the calculation to run.  You'd want to look/test your field on a form on a test object (project, task, etc) so you can save and see the calculation rendering proper (I know you can test and did in the form editor, that's what its for, but I also like to see it work real-time).  Sorry for the misunderstanding.  

If my response answered your question, please mark it answered, so others can find the answer
Terms & ConditionsAccessibility statement

Loading footer...