Set analiysis explanation

[#1]

Please can someone add set analysis to this

expression so that NO other selections change the result.

=count(if(DayDiff>0,SCO_No))

Can you also explain what each part of this goes and what it does...

Thank you for previous examples but unsure on this one.

ie: > {   etc.

Thank you

[miguelbraga]

Hi Emma,

You can make a field like this in the table where have the field [DayDif]:

     if(DayDif>0, 1, 0) as FlagDayDif

Then you can make a set analysis like this:

=count({$<FlagDayDif = {"1"}>} SCO_No)

Hope this helps

Regards,

MB

[avinashelite]

try like this :

=count({1<SCO_No={"=if(DayDiff>0,SCO_No)"}>}SCO_No)

there 1 will count it for the whole set and will not vary on the current selection

" " double quotes is for the evaluation of your expression 

[miguelbraga]

This expression only counts when the value of the FlagDayDif is 1. The only way the FlagDayDif is 1 is when DayDif is greater than zero

[amit_saini]

Emma,

You can do like this:

=count({$<DayDif = {">0”}>} SCO_No)

Thanks,
AS

[sunny_talwar]

Try this:

=Count({1<DayDiff = {'>0'}>} SCO_No)

[jonathandienst]

If you want to ignore all selections, then you can simply add {1} to the expression:

=count({1} if(DayDiff>0,SCO_No))