Set Analysis

[marco_puccetti]

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

[sunny_talwar]

Try this may be:

Count({<[FIELD A]={"=$([FIELD A])-1"}>}DISTINCT [FIELD B])

[sunny_talwar]

Or

Count({<[FIELD A]={"$(=[FIELD A])-1"}>}DISTINCT [FIELD B])

[marco_puccetti]

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

[#5]

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])

[sunny_talwar]

What filters are you trying to put through your set analysis ({<[FIELD A]={"=$([FIELD A])-1"}>})?

[marco_puccetti]

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

[marco_puccetti]

I have tried to check the correct form of the "$(-1)" ststement being an year but the computated dimension is not working with this stetement: =$(-1).

Anyone can explain me how to get this data inside the table?

Thanks

Marco

[sasiparupudi1]

try

Count({<[FIELD A]={"=[FIELD A]-1"}}DISTINCT [FIELD B])

[marco_puccetti]

It doesn't work.

I have tried also with this but it's still not working

Count({<={"=$(=(-1))"}>}DISTINCT )

Thanks

Marco