Expression Help..

[#1]

Hi All,

Please see the attached QVW.

I'm getting the result as

1/11/2014 but expecting is 1/11/2014,P1,2014

[Nicole-Smith]

This thread is already being replied to here: Expression Help

[#3]

Hi Nicole,

I didnt get the expected result.Not sure how to post QVW for the existing thread...so created a new thread

[MK_QSL]

=MAX({1<[System] = {"DAPTIVE"}>}(date([Apply to Period Date ID])))

& ',' &

Only({<System = {"DAPTIVE"}, [Apply to Period Date ID] = {"$(=Max([Apply to Period Date ID]))"}>}Period)

& ',' &

Only({<System = {"DAPTIVE"}, [Apply to Period Date ID] = {"$(=Max([Apply to Period Date ID]))"}>}Year)

Same way use for LAWSON..

Hope this help.