Set analysis Syntax not working properly for current year and PY

[deepakqlikview_123]

Hi All,

PFA.

in text boxes I have shown it seems results are not showing properly for current year and Previous year.

We  need to show the results for max year and max year - 1 for max month.

Please suggest.

Thanks

[#2]

Hi,

Syntax error is there

Correct syntax is

sum({<DOJ={$(=Max(Year)),$(=max(year-1))}>}sal)

[phaneendra_kunc]

Looks ok to me. Where exactly you are not seeing the data or not able to match to the source.

[fashid]

Loooks ok to me as you do not have data for 2018 it returns the correct result for 2017 .

Where do u find the problem .

[deepakqlikview_123]

Hi,

Thanks for the reply.

It seems it is not showing the results for maximum  month number.

Regards,

Deepak

[stabben23]

Hi,

if you Select what you have in Your Expression, you have this:

Your Expression is also a little bit strange if you only what to see previous and current max(year).

Can you tell us more what you expect?

[fashid]

The maximum month number for the the maximum year 2018 is April which does not have corresponding values in the Data field hence u are unable to see the values.

regards,

Nadeem

[deepakqlikview_123]

Hi,

For example

For 2017 max month is july so only data for july need to show.

For 2016 data only for Apr.

Thanks

[fashid · Accepted solution]

The in that case this is your corrected expression for current Year

=if((Sum({<Year={'$(=(max(Year)))'},Month_Num={"$(=max(Month_Num))"},Flag={'P&L_Actual'},PARTICULARS={'Net Revenue'}>}Data))

=0,

(Num(Sum({<Year={'$(=(max(Year)-1))'},Month_Num={"$(=max(Month_Num))"},Flag={'P&L_Actual'},PARTICULARS={'Net Revenue'}>}Data)*1000,'$ #,##0 K')),

(Num(Sum({<Year={'$(=(max(Year)))'},Month_Num={"$(=max(Month_Num))"},Flag={'P&L_Actual'},PARTICULARS={'Net Revenue'}>}Data)*1000,'$ #,##0 K'))).

check the screenshot

Regards,

Nadeem

[fashid]