Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This should be really simple but I can't see it.
We have a selection box (Company) with four possible selections (say 'ABC','DEF','GHI','JKL'). I have a text box that reads the selection and uses it concatenated with 'Report' to provide a header (=Company & ' Report').
So selecting 'ABC' produces a text box with 'ABC Report' etc.
However we select two specific Company selections, say 'DEF' and 'GHI' I want the text box to say 'MNO Report'.
I tried:
=if(GetCurrentField(Company) ='DEF' and GetCurrentField(Company)='GHI,'MNO',Company) & ' Period Report'
Any ideas?
May be this
If(SubStringCount(Concat(DISTINCT '|' & Company & '|'), '|DEF|') = 1 and SubStringCount(Concat(DISTINCT '|' & Company & '|'), '|GHI|') = 1, 'MNO', Company) & ' Period Report'
May be this
If(SubStringCount(Concat(DISTINCT '|' & Company & '|'), '|DEF|') = 1 and SubStringCount(Concat(DISTINCT '|' & Company & '|'), '|GHI|') = 1, 'MNO', Company) & ' Period Report'
Use GetCurrentSelections() instead of getcurrentfield().
Brilliant as usual Sunny!
Thank you
Hi Christine,
Try:
If(Concat(Company,'|') ='DEF|GHI', 'MNO Report', Company & ' Report')
Regards
Andrew