Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i need to know if is anything wrong in this expression, it doesn't return me the expected values:
Count({<[FIELD A]={"=$([FIELD A])-1"}}DISTINCT [FIELD B])
Thanks
Marco
if you only have year as dimension above (without set analysis) should works
Try this may be:
Count({<[FIELD A]={"=$([FIELD A])-1"}>}DISTINCT [FIELD B])
Or
Count({<[FIELD A]={"$(=[FIELD A])-1"}>}DISTINCT [FIELD B])
Hello with this statement:
=Count({<[FIELD A]={"=$([FIELD A])-1"}>}DISTINCT [FIELD B])
return exactly the same data returned with this one:
Count(distinct [FIELD B])
applied on a selection on FIELD A.
Is it possible?
Thanks
Marco
Is FIELDA only a number list from where you are selecting only one value? If yes, try this
=Count({<[FIELD A]={"=$([FIELD A]-1)"}>}DISTINCT [FIELD B])
What filters are you trying to put through your set analysis ({<[FIELD A]={"=$([FIELD A])-1"}>})?
Field A is a list of year and the table rows get the data from that list.
I have tried with the below expression but it doesn't print the previous year data.
Count({<={"=$(-1)"}>}DISTINCT )
Thanks
Marco
try
Count({<[FIELD A]={"=[FIELD A]-1"}}DISTINCT [FIELD B])
It doesn't work.
I have tried also with this but it's still not working
Count({<={"=$(=(-1))"}>}DISTINCT )
Thanks
Marco