Pick Minimum Positive value

[raghavsurya]

Hi All,

I am currently picking up minimum values among 3 variables with below mentioned Min function.

nummin (CVRev,CVP, CVEB, CVBV)

With one of the valubles returning negative value.... I need to pick minimum positive values. Can you please suggest how to modify the expression.

Regards,

Raghav

[#2]

Hi,
Try this expression,

nummin (if(CVRev>0,CVRev),if(CVP>0,CVP),if(CVEB>0CVEB),if(CVBV>0,CVBV))

I know this might not be the most efficient way to do this but, nothing strikes me other than this.

-Haneesh

[raghavsurya]

Thanks Haneesh...... its working

Regards,

Raghav

[#4]

Yeah, this one will definitely work. But, the expression is complex as it has to call the if condition 4 times for every row and this can consume more memory if the data volume is high.

As a best practice, it is advisable not to use such complex statements. In this case, I guess we don't have any other option now 🙂

Cheers,

Haneesh