First and Last value

[#1]

Hi all.

I have a table:

Date	Value 1	Value 2
01-01-2014	1	-
02-01-2014	2	-
03-01-2014	1	2
04-01-2014	4	-
05-01-2014	1	-
06-01-2014	6	-
07-01-2014	2	-
08-01-2014	8	4
09-01-2014	5	-
10-01-2014	6	-

I want see:

1) In first text object - first value on column "Value 2" - that is "2"

2) In second text object - last value on column "Value 2" - that is "4"

I have a NULL value (or non value) in column "Value 2"!!!

Any idea how it do?

I need use function: FirstSortedValue([Value 2], Date) ???

But i see "-".

Thank you.

[amit_saini]

Dmitry,

Try this:

Checked "Suppress When Value us Null " option and see the result.

Thanks,
AS

[#3]

Amit, thank you.

But it works in Pivot table.

I need in different text object:

2

4

[tresesco · Accepted solution]

Try like:

FirstSortedValue({<[Value 2]-={'-'}>}[Value 2],Date) , and

FirstSortedValue({<[Value 2]-={'-'}>}[Value 2],-Date)

[ashfaq_haseeb]

Hi,

May be like this.

Regards

ASHFAQ

[simenkg]

in your script, create a flag:

load

...

if(isnull(Value 2), 0,1) as ValidValue2Flag,

...

From Input.

Then you use

FirstSortedValue({$<ValidValue2Flag={1}>}[Value 2],Date)

[#7]

Tresesco Thank you!

It work.

Can you explain me this expression: {<[Value 2]-={'-'}>}

I'm confused by in the signs...