Understanding Alt statement

[dseelam]

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

[vamsee · Accepted solution]

Alt() returns the first found numeric value in the expression.

Syntax:

alt(case1[ , case2 , case3 , ...] , else)

For Example

ALT('ABC',1) returns 1.

Alt (Conditional) Function

-----

In your case, if ForecastMacthInd has any number value for the record it considers that else it takes 0.