Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I'm using a variable for take filter and use in my set analysis, but don't works. Any help?
vCor = GetFieldSelections(COR_RACA)
KPI = Count ( {$<COR_RACA= {"=$(vCor)"}>} UNIC_ID)
Why this doesn't works? If I do not use the variabel it's better
Try this?
KPI = Count ( {$<COR_RACA= {"$(=$(vCor))"}>} UNIC_ID)
OR just
KPI = Count ( {$<COR_RACA= {$(vCor)}>} UNIC_ID)
Try this?
KPI = Count ( {$<COR_RACA= {"$(=$(vCor))"}>} UNIC_ID)
OR just
KPI = Count ( {$<COR_RACA= {$(vCor)}>} UNIC_ID)
If you want to handle multiple field selections as well, you need to include the delimiters. Try like
For vCor (include the = sign)
=Concat(DISTINCT COR_RACA,Chr(39)&','&Chr(39))
KPI
=Count({<COR_RACA={'$(vCor)'}>} UNIC_ID)