Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I f I use like this works
=Sum({<AnoAdmissao ={2015},MesAdmissao={10},DescricaoSituacao = {Ativo}>}Qtd_colaboradores)
But when I use the script below it doesn't work:
=Sum({<AnoAdmissao =Year(Today()),MesAdmissao=Month(Today()),DescricaoSituacao = {Ativo}>}Qtd_colaboradores)
Could anyone help?
sum({$ <
AnoAdmissao ={"$(=year(today()))"},
MesAdmissao={"$(=num(month(today())))"},
DescricaoSituacao={Ativo}>
}
Qtd_colaboradores)
=Sum({<AnoAdmissao =
{"$(=Year(Today()))"},
MesAdmissao={"$(=Date( Month(Today())),'MM')"},
DescricaoSituacao = {"Ativo"}>}Qtd_colaboradores)
sum({$ <
AnoAdmissao = {"$( =year(today()))"},
MesAdmissao = {"$( =num(month(today())))"},
DescricaoSituacao ={Ativo}
>} Qtd_colaboradores)
hi,
please try:
=Sum({$ <AnoAdmissao ={"$(=year(today()))"}, MesAdmissao={"$(=num(month(today())))"},
DescricaoSituacao={Ativo}>}Qtd_colaboradores)
Thanks
Please close the thread as correct.or helpful...hope this wil help to others while seaerchng
thanks
Suresh
It is not possible to use normal functions in the position where you use them, since the parser expects a Set, i.e. either a {...} construction, or a Set function, E() or P().
See more on
HIC