Skip to Content
Former Member
Nov 07, 2017 at 12:50 AM

I am getting an invalid data type error in WEBI


Hi Guys,

I need help to resolve this problem.

I need to create a variable to calculate some risk but I am having some issue in WEBI

The formula I am using works fine in excel but not in webi.

Excel formula

=IF(T=0,1,IF(T<N,(N-T)/N,IF(T=" Very Late",1,0)))

I did this in webi

If([V_EPS]=0;1; If([V_EPS]<KTIc Qty];([KTIc-V_EPS])/[KTIc]; If([V_EPD]=" Very Bad"; 1;0)))

Where T = EPS, N=KITc,

I am getting this syntax error

The expression or sub-expression @ position 13 in the “=” function uses an invalid data type (IES 10037)

Any help?