Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Folks,
would like to know whats actually happening with below statement (what exactly its deriving)
If (ActualMatchInd + alt(ForecastMatchInd,0)=1, 'Yes', 'No') as ForecastItemMatchInd
Thanks,
D
Alt() returns the first found numeric value in the expression.
Syntax:
alt(case1[ , case2 , case3 , ...] , else)
For Example
ALT('ABC',1) returns 1.
-----
In your case, if ForecastMacthInd has any number value for the record it considers that else it takes 0.
Alt() returns the first found numeric value in the expression.
Syntax:
alt(case1[ , case2 , case3 , ...] , else)
For Example
ALT('ABC',1) returns 1.
-----
In your case, if ForecastMacthInd has any number value for the record it considers that else it takes 0.