Calculated Condition - required 2 fields, optional 1 field

zagzebski — Sat, 23 Nov 2013 17:50:39 GMT

I need to write a calculated condition for an object that does the following:

Required selections:

Month and Year

Optional selections:

Department Name

Nothing else can be selected. Struggling with getting this to work.

Thanks in advance for any assistance!

Steve

Re: Calculated Condition - required 2 fields, optional 1 field

Anonymous — Sat, 23 Nov 2013 18:27:57 GMT

Steve

Have you looked at the GetFieldSelections() command ?

I often find it best to test such commands in a Text Box, using a Value Expression of say something like :

=GetFieldSelections( [YourFieldName])

Then when you have seen what it returns when you do various selections on YourFieldName, then you can build your Calculation Condition Expression.

Best Regards, Bill