Generalhttps://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)Re: Possible to "examine" a calculated field?https://www.infopathdev.com:443/forums/thread/121210.aspxFri, 05 Jul 2019 16:03:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121210Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121210.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121210In InfoPath, you should be able to use the mod function for this - like my:field1 mod 2 will return 0 if even and 1 if odd. See attached sample, save locally, right click and select Design then preview.Possible to "examine" a calculated field?https://www.infopathdev.com:443/forums/thread/121200.aspxMon, 01 Jul 2019 21:42:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121200Daryl K0https://www.infopathdev.com:443/forums/thread/121200.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121200I have a calculated field that determines if a certain whole number is even, by dividing the number by two, then subtracting the rounded version of the result by a precise version of it. If I do this in a calculated column it comes out great; 0.5 if an odd number, 0 if an even number. This is not for display, however. I want another rule to "examine" the outcome and do actions based on said outcome, but it doesn't seem possible to do this without binding the formula to a column. <br /><br />Obviously the value is of no use to record, so I don't want to go that route. I only need it as an IF/THEN result in my form.<br /><br />Is this possible? If not and I have no choice but to put it in a column, how would this best be done? As an experiment I did try putting the formula into the Default value of a text box (formatted as a number) but it did not seem to work.