I created a variable Var1 with below formula.
Var1 =If [EG_EQNAME]="HP_PVD_TiN-01(A-C01)" Then [AC-MFT].[EQ_PRD] Else
If [EG_EQNAME]="HP_PVD_TiN-02(A-C02)" Then [AC-MFT].[EQ_PRD] Else
If [EG_EQNAME]="HP_PVD_TiN-03(A-C03)" Then [AC-MFT].[EQ_PRD] Else
If [EG_EQNAME]="HP_PVD_TiN-04(A-C04)" Then [AC-MFT].[EQ_PRD] Else [Mft]
Then used Var1 in another variable Var2 with below formula.
Var2 =If [EQ].[Eqid] InList("76401";"76402"; "76403";"76404") Then Var1 Else [Mft]
Finally I used Var2 in my report.
It worked perfectly.
Regards,
Thiru
Hi Thirupathi ,
Check EQID objects qualification .It seems like measure.If it measure then no need to use double quotes(" ")
Add comment