Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
i use a Sum with Set-Expression:
Sum({$<Jahr={"=$(=getfieldselections(Jahr))"},Periode= {"<=$(=getfieldselections(Periode))"},Werttyp={'Ist'}>}Wert)
It works fine, when in the Filters for the Fields "Jahr" and "Periode" Values are selected.
When i use Formulas in the Filter-Fields:
Field "Jahr": =Jahr=Year(Today())
Field "Periode": =Periode=Month(Today())
there is following Output for the Formula:
and the KPI is no longer calculated. It is 0.
Has someone the same issue or an Solution for me?
For Info: We want to use the Formulas in a Bookmark to make it user-friendly easy to select the actual Year and Month for this Sheet.
Thanks and best regards, Frank
Try this
Sum(
{$
<Jahr={"$(=Year(Today()))"},
Periode={"<=$(=Month(Today()))"},
Werttyp={'Ist'}
>}
Wert)
Hello Chant4U
thank you, but this does not solve my problem.
We want to keep the Set-Expression in the KPI. So the user can select anything in the Filters.
Best regards Frank