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