Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning all,
I am trying to develop a set of nested paramerised expressions sharing multiple parameters ($1, $2, $3 and $4) across the set but I cannot get the nesting to work. When used in their full form (manually expaned) they all work OK.
My objective is for the final set to provide flexibility across multiple processes and so ease future application development / maintenance.
eReceived =
(Num(
Sum( { $ < $1, [Date] = {'<=$(vLatestDate)'}, [_Type] = {'StoresMetric'}, $2, $3 > } [# Received])
,'#,##0'))
eFailureLinesEO =
(Num(
If(
$(vIncludeEOs), Sum( { $ < $1, [Date] = {'<=$(vLatestDate)'}, [_Type] = {'FailureItem'}, $2, [Excused Occurance] = {'-1'}, $4 > } [# Lines])
, 0)
,'#,##0'))
eProcessed =
(Num(
(
Sum( { $ < $1, [Date] = {'<=$(vLatestDate)'}, [_Type] = {'StoresMetric'}, $2, $3 > } [# Processed])
+
$(FailureLinesEO)
)
,'#,##0'))
eProductivity =
(Num(
(
$(eProcessed)
)
/
$(eReceived)
,'##0.0%'))
The intended usage for parameters is as follows:
$1 an optional shared parameter to (optionally) select sets which represents a particular Year e.g. [Year] = {$(vTY_Year)}
$2 a second shared parameter typically to be used with a Date related Flag e.g. [_TY_YTD] = {1}
$3 a dedicated parameter (used within one expression) to (optionally) select a set which represents a process area e.g. [Process] = {'$(vProcess)'}
$4 an optional dedicated parameter (used within another expression) to (optionally) select a set which represents a process failure e.g. [Failure Point] = {'$(vFailurePoint01)'}
$(eFailureLinesEO( [_TY_YTD] = {1}, '', '', [Failure Point] = {'$(vFailurePoint01)'})) seems to work OK
Thanks in advance for any help / advice offered.