This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Result Value Different in Expression Testing Then on View or Db

Posted on 10-19-2021 12:45 PM
maccollaflower
New Member
Reply posted on --/--/---- --:-- AM

Hi All,

I have an expression setting the value of a percent column. When I test the expression it work perfectly. Currently it should be 100% done with a value of 1.00 and that is what the test result shows. Now when I view this data either in the form or in the database after it is saved for some reason it is 20%. It seems that my expression where I am using SELECT() functions work correctly during testing but are not working as expected outside of testing. Any idea why this would be? This is the first time I have had a test value that is different than the actual so I am not sure how to trouble shoot this one.

Database
3X_e_c_ec808cb4a80b60ae2399459b59b2460bcfd5b438.png
Testing
3X_8_4_84faa4c1bdcce626d50487dd1534833dccb08706.png
Form View

3X_5_3_530b8746e6999a4cc7f44d702037bdeba5a4c3f4.png

0 9 417
Topic Labels
0 Likes
9 REPLIES 9
Top Labels in this Space