Fetch the First Not NULL Value

[#1]

Hi All,

Hope everybody is good.

Can somebody please help me for the below scenario?

YEAR	SALE
2000
2001
2002
2003	678
2004	243
2005	800
2006	456

I want an expression to fetch the first Year value having NOT NULL value of SALE.

In this case I want 2003.

Your Help is appreciated.

Regards

Srawan

[Digvijay_Singh]

May be like this -

=Min({<SALE={"<>ISNULL()"}>}YEAR)

[sunny_talwar]

May be this:

Sum({<YEAR = {$(=Min({<YEAR = {"=Sum(SALE) > 0"}>}YEAR))}>}SALE)

[swuehl]

If there are really only values for years > 2003, you can try

=Min({<SALE = {"*"}>} YEAR)

[sunny_talwar]

Sample image and app attached

[vishsaggi]

Where do you want this to show?

Extending Vijays's Expression you can also use adding a straight table with Year Dim and Expr as below

= Min({< SALE -= {''}>} SALE)

[swuehl]

That's not returning 2003, Sunny

Srawan, if your SALES values could also be just blank, you could also try

=Min({<SALE = {">0"}>}YEAR)

or

=Min({<SALE = {"=Len(Trim(SALE))"} >} YEAR)

[sunny_talwar]

I am not sure if the OP needs to just return the year or the sales associated with that year. If the year is needed, you are bang on target

[swuehl]

Yes, could be the case.

Another option for this would be

=FirstSortedValue({<SALE = {">0"}>}SALE, YEAR)

[#10]

Thanks  a lot the solution worked.