?

[xyz1]

.

[Anil_Babu_Samineni]

Perhaps something like this? What does that 88 number?

Count({<Role = {'*NO_PWDEXP*'}>+<[Claimed/Unclaimed Account] = {'Has Manager'}>+<Controls = {'NA'}>+<[Last login Time] = {"$(=(Floor(Date(Today()))-Date([Last login Time]))>88)"}>} If(WildMatch([Member of], '*ALL_Generic_Accounts*'),Accounts)

[Anil_Babu_Samineni]

Agrim Sharma wrote:

if any Account unsatisfied any one of the conditions then it should be unsecured account , so i want total of them

Not sure, I understand this?

[xyz1]

.

[Anil_Babu_Samineni]

Why it is not? Let me know the value you got in your Straight table?

Floor(Date(Today()))-Date([Last login Time])

[xyz1]

.

[Anil_Babu_Samineni]

Can you create same chart and share QVW to test?

[xyz1]

.

[Anil_Babu_Samineni]

This never give output -- =date(Today())-date([Last login Time])

Note - Cause, [Last login Time] contains lot dates not only one.

FYI - When i use this, In text box  i got 48?

=Count(If((date(Today())-date([Last login Time]))>80, (date(Today())-date([Last login Time]))))

[xyz1]

.

[Anil_Babu_Samineni]

In your model there is no field called "[Claimed/Unclaimed Account]" can you create this and get 5 in text object and the share it here. We will test you. Predominantly it should work. We will try out with in set analysis instead adding/club to each with first one.