Conditional Expression.

[renuka_sasikumar]

Hi,

I have a CY Sales & PY Sales

Now when I select 2015 I get data for this year but while comparing data with PY I get all the months data but I should only get data as of CY Max month.

For Eg:

2015

JAN

FEB

MAR

APR

MAY

JUNE

JULY

AUG

SEP

OCT

NOV

DEC

TOTAL

CY Sales

XYZ

XYZ

ABC

PY Sales

XYZ

XYZ

XYZ

XYZ

XYZ

XYZ

XYZ

XYZ

XYZ

XYZ

XYZ

XYZ

ABC

Here for PY I should get data only till Feb.

Is there any possible ways.

Thanks & Regards,

Renuka S

[Peter_Cammaert]

This is a LYTD comparison. Add the following set modifier to your PY expression:

..., Month = {'$(=Max(Month))'}...

This will restrict the last month displayed in PY to the maximum month available in the selected year.

[renuka_sasikumar]

Hi,

Thanks for immediate reply.

But its not working.

[Peter_Cammaert]

It should, at least as far as you description goes.

Can you post a sample app with the same behavior? Otherwise we may keep guessing for a while...

[Peter_Cammaert · Accepted solution]

I'm sorry, it shouldn't work. I made a mistake in my suggested modification. What about this one:

..., Month = {'<=$(=Max(Month))'}...

[renuka_sasikumar]

Hi,

Thanks I did the same Now its working.

Thank you very much.

Thanks & Regards,

Renuka S