Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
this set analysis works well but if i select anything it gives me wrong result.
anyhelp please
sum({<Date={">$(=mindate)<$(=Date(mindate"+365))"}>}
if(IsNum(Right(Badgeages,5))=-1,if([Code d'entreprise]='12',
interval(num(Time#('02:00','hh:mm')),'hh:mm'),
interval(num(Time#('01:00','hh:mm')),'hh:mm'))))
sum({<Month = , Week = , MonthYear =, Quarter= , Date={">$(=mindate)<$(=Date(mindate"+365))"}>}
if(IsNum(Right(Badgeages,5))=-1,if([Code d'entreprise]='12',
interval(num(Time#('02:00','hh:mm')),'hh:mm'),
interval(num(Time#('01:00','hh:mm')),'hh:mm'))))
I have doubt whether this is ok or no
Date={">$(=mindate)<$(=Date(mindate"+365))
the selection doesn't work.
did you have any idera how to write this : Date={">$(=mindate)<$(=Date(mindate"+365)) in another way
you can go with
Date = {">$(=min(mindate)) <$(=addmonths(min(mindate),12))"}
not working
Please post your qvw here