Set analysis Issuse

[Anonymous]

Hi,

    i usesd set analysis concept for getting of max date and previous date.It works good but when i select the date field,month field the sum of previous date related data shows 0.

Please help me

Please find following attachemnts for reference.

Thanks,

[pokassov · Accepted solution]

Hi!

Try this:

=if(MTD='Day','Prev''s Day: ' & num(sum({$<Day=,Month=,Date={'$(=v_previous_date)'},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'#,###')

,'Prev''s Month: ' & num(sum({$<Day=,Month=,Month={'$(=v_prev_month)'},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'###,###')

)

With out deleting Day and Month you are looking in overlaping day,month (28 and feb) and previos day (27 feb).

this overlaping is zero.

[ladislav]

Hi.

Your only issue is that there is no data meeting condition for Jan/28/2015. That's why you get 0. There is no such entry in your table. If you deselect the date you get result. Otherwise fill your table with Jan/28/2015 Key_Data.
Look on picture.

Ladislav

[Anonymous]

Hi cepren,

Thanks for your help its working fine.

Thanks,