Set Analysis syntax - nested functions

[#1]

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

[#2 · Accepted solution]

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)