Skip to Content
0
Apr 27, 2018 at 03:43 PM

Count Issue

106 Views

Hi Experts,

I have vertical report table with multiple fiscal years as rows:

FY13 FY14 FY15 FY16 FY17

# proj 20 13 22 51 56

Below is the Main formula for # Proj:

=Sum(Count([Project ID])) Where ([FY Desc]="Current FY-1" And [tEST]<>0 And Not(IsNull([tEST])))

tEST =Sum(Count([Project ID])) Where ([FY Desc]="Current FY-1")

Now when i include Project ID into the table, it is showing the right expected count : 55

but when exclude it shows 56

My expected count is 55. PLease help with # Proj formula logic.

Appreciate your quick reply

Thanks,

Dinya