Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Please help me to translate this formula in set analisys mode, i don't know how i can do it.
this is the formula :
count({$<flag_tipo_data= {ifas},id_fas= {1},Anno=,Mese=,Giorno=,data_short=,Settimana=>} distinct if(FakeData=fake_dt_hi,
if(dt_in_fas_num <= date_hi and (date_hi< dt_out_fas_num or IsNull(dt_out_fas_num)),id_e2e) ,
if(( FakeData< fake_dt_out_fas or IsNull(dt_out_fas_num)) and FakeData >= fake_dt_in_fas,id_e2e) ))
I wrote in bold the fileds which are Variable.
thx a lot for you support.
Bye.
Tinamus - If possible, please can you load a QV document with sample data? We can convert your expression into set analysis but we need to test the same. Also it will be very useful to write your requirement in general english, it helps other users to understand quickly.
Cheers - DV