Mulitple Formula

[Fez the Blue]

Is there a way of setting an single expression formula to return mulitple
results dependent on an option group.
for example if option a selected then formula a is return, if option b then
formula b, and so on
Thanks in advance
FtB

 

[Greg Collins [InfoPath MVP]]

I'm not completely sure what it is you want to do, but it sounds like you might need to use code in an OnAfterChange event handler to accomplish what you want.

Can you explain in more detail?

 

[Fez the Blue]

Basically what I'm setting up is an audit tool, however the level of audit
required is depenedent on a series of factors.
Factor A - the audit corresponds to a 'Simple' problem with it's own scoring
criteria
Factor B is a 'Complex' issues with furter scoring over and above the simple
problem

I don't particularly want to have to do two separate sections, what I was
trying to achieve was to set up an expression box with formula linked to an
option button which would select the formula to use dependent on the Factor A
or B

Hope that's a little clearer
FtB

 

[Greg Collins [InfoPath MVP]]

It might be possible to set up a drop-down with a formula... but in order to use that formula, you'll have to write code. The InfoPath UI (so far as I know) won't allow you to use the formula as anything other than a text string. Now it might be possible using the "eval()" function... but you'd have to try that.