Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, today in my calculated expression i have this
if($(vDay) = 1, FLAG, Aggr(If(Count(DISTINCT {<FLAG = {'NO COMP'}>}FLAG)/Count(DISTINCT {<FLAG = {'NO COMP','COMP'}>}FLAG) > 0.10, 'NOCOMP', FLAG), DEV_ID_LOC, DEPADR_PAYS_LIB, MAG_LIBELLE, JOUR_ID))
I want to change it like this
If ($(vDay) = 1
Get the value of FLAG where {<FILTER_JOUR_ID = {"$(=$(vNdebut))"}>}
Else
Aggr(If(Count(DISTINCT {<FLAG = {'NO COMP'}>}FLAG)/Count(DISTINCT {<FLAG = {'NO COMP','COMP'}>}FLAG) > 0.10, 'NO COMP', FLAG), DEV_ID_LOC, DEPADR_PAYS_LIB, MAG_LIBELLE, JOUR_ID))
only for the period selection in [Groupe1]* $}
A bit confused, Please hint me
Thanks in advance
I tied this for the first part unfortunately it did not work
if($(vDay) = 1, only({<FILTER_JOUR_ID = {"$(=$(vNdebut))"}>}FLAG),
2nd try
if($(vDay) = 1, only({<FILTER_JOUR_ID = $(vNdebut)>}FLAG)
3rd try
if($(vDay) = 1, if(FILTER_JOUR_ID ={"$(=$(vNdebut))"},FLAG,null())
This is for informaiton