Forum Discussion

KC2's avatar
KC2
New Contributor
19 days ago
Solved

If Then Else Statement to return Annotation in UD8

Hello-

Is there any reason why the below if , then, else statement is not working correctly? Val2 has data when I only return it in a test dynamic calc, but when incorporated into the below formula, it is reading a zero for Val2. Any help would be greatly appreciated:

 

  • KC2's avatar
    KC2
    3 days ago

    Yes, that is correct, I found the FIX, I needed to add the Scenario specifically 28,29 31 & 32. Then the values of non zero were present in the evaluation starting on line 35. Thank you

2 Replies

  • Russell's avatar
    Russell
    New Contributor III

    So, you are saying that when you declare and instantiate val2 above it is not zero but when applied in val1 + val2 it shows as 0? Or, are you saying that when you return cellExResult it is showing 0?

    • KC2's avatar
      KC2
      New Contributor

      Yes, that is correct, I found the FIX, I needed to add the Scenario specifically 28,29 31 & 32. Then the values of non zero were present in the evaluation starting on line 35. Thank you