Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I have an expression that looks like this
=subfield(concat(DISTINCT{MLState<Date = {"$(='>=' & Min([Cal Date]) & '<=' & Max([Cal Date]))"}>}Date, ';', Date), ';', varEvrank)
It returns a single Date based on the users selection of varEvrank and [Cal Date]. It works perfectly if I paste this expression into a text box.
I'm trying to insert this subfield into another set analysis expression, so that I get a text box with all the relevant information for that Date.
=concat({MLState<Date = {'INSERT SUBFIELD RESULT HERE'}>}ML.machname & ': ' & Details,';',Date)
No matter what I do the syntax is incorrect. I've tried so many different ways that I'm beginning to get very frustrated.
Can anyone help?
Thanks in advance
Karen
Never mind! I've done it. At LAST. $(=subfield.....etc)
=concat({MLState<Date = {$(=subfield(concat(DISTINCT{MLState<Date = {"$(='>=' & Min([Cal Date]) & '<=' & Max([Cal Date]))"}>}Date, ';', Date), ';', varEvrank))}>}ML.machname & ': ' & Details,';',Date)
Never mind! I've done it. At LAST. $(=subfield.....etc)
=concat({MLState<Date = {$(=subfield(concat(DISTINCT{MLState<Date = {"$(='>=' & Min([Cal Date]) & '<=' & Max([Cal Date]))"}>}Date, ';', Date), ';', varEvrank))}>}ML.machname & ': ' & Details,';',Date)