Set Analysis Help

[#1]

hi All,

i'm need your help please.

how to transform this request in Set Analysis :

if(IsNull(Cal_DAY),SUM(D1_D7)/sum(REG),if(Now()>Cal_DAY+8,SUM(D1_D7)/sum(REG)))

Thanks

[dirk_konings]

Hi

You can't do a nested if within SetAnalysis. Checking on NULL is also not possible via SetAnalysis.

SetAnalysis is for making 'Selections' in your expression, not testing a value.

Dirk

[#3]

but i can use Cal_day={''} to define a null value

[dirk_konings]

no, but you could create an extra field in script which has a value 'X' when isnull(Cal_day)

This new field could be checked with SetAnalysis

[er_mohit]

Try this

if(IsNull(Cal_DAY),SUM(D1_D7)/sum(REG),if(Now()>Cal_DAY+8,SUM(D1_D7)/sum(REG)))

if(IsNull(Cal_DAY),sum({<Cal_DAY={" "}>}D1_D7)/sum(REG),

if(Day(today())>Cal_DAY+8,SUM(D1_D7)/sum(REG)))

[#6]

ok i'll change my field to 'X' when Cal_day IsNull, and then how to write it in Set Analysis ?

it seems that Now() doesnt work

[#7]

you expression works, but still using IF.

the IF statement seems to refresh my report every 5 seconds, which complicates the use of the chart.

[dirk_konings]

You better use Today() because now is the current system timestamp.

Dirk

[#9]

right !

[#10]

Up