-
Here is the formula and it seems to be working correctly now that I've sent you this email.(there are 11 questions)
1-(TotalOfNo) / 11-(TotalOfNA)
Thank you
-
Sure - just add another field and have the default be TotalOfMDYes + TotalOFMDNo - did you run into an issue when you tried that?
-
Hello, I'm passing drop down values to a field and want to use that field in a calculation. Is this possible using calculated value?
Drop down is Yes, No, N/A. I use the count function to count each box that is selected, in this case, Yes =1:
count(MD18[. = 1] | MD23[. = 1] | MD25[. = 1] This total ...
-
That is a great idea, I will do just that.
-
Hi - So, I would use the GetUserProfile method to return that info - I think you will have to set the account name to a substring-after result to get back just the email portion, but you could always try it with the full claims account, see what happens. Then run the query, and you should have what you need.
-
Hi - so I'm wondering if you can attach a screenshot or something to help me understand - you can add an attachment to a post under the Options tab in a reply.
-
Can I see your form? You can attach it under the Options tab - I don't think this is a limitation - I was pretty sure we picked up all instances of the attachment field, but I can double check the code.
-
Even all the same service packs & patches? If so - I'd probably uninstall / re-install InfoPath.
-
Use workflow with some conditions and a helper field - so - for example, you could have a field that just indicates what workflow you want to run, and in your submit button, set the field to a value like "submitted" and check for that in your workflow. On open, do a submit via form load rules, and set that field to "opened" and ...
-
I think it could be that when the days valid is returned to your form, the value has a decimal point in it. I found in a test form that if I used a field with a decimal for my "DaysValid" equivalent, I had and ERR? too! You could try using the round function or substring-before to remove the decimal. In your rule, you could have a ...