Understanding Alt statement

dseelam — Tue, 18 Sep 2018 19:53:42 GMT

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,

Re: Understanding Alt statement

vamsee — Tue, 18 Sep 2018 20:11:23 GMT

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.