Assign value based on time

[Former Member]

Hello buddies,

I have a SAP Business Intelligence report question.

I want to create a variable like this.

IN       CN       TIME     VARIABLE

1          101      00:52    P

1          102      00:58    C

1          103      01:25    C

2          104      00:58    C

2          105      00:51    P

I. E.  The variable will assign P value to the first time under lN

[former_member1114656]

Hi,

Taking 12345 as an example, is this how you want your report to be displayed?

CN	IN	TIME RECEIVED	Variable
1234	12345	08-02-2015 01:02	C
1213	12345	08-02-2015 01:02	P
1617	12345	08-02-2015 01:26	C
2728	12345	08-02-2015 01:35	C
2930	12345	08-02-2015 01:50	C

Regards,

Keerthan

[Former Member]

Hi Amit,

Thank you for the reply but my condition is a little different.

Explaining the requirement again.

Following is the Data

CN	IN	TIME RECEIVED	Variable
1234	12345	08-02-2015 01:02	P
1213	12345	08-02-2015 01:15	C
1415	111213	07-02-2015 11:12	C
1516	111213	07-02-2015 11:36	C
5678	678910	08-02-2015 21:26	P
1617	12345	08-02-2015 01:26	C
1819	111213	07-02-2015 11:40	C
2021	678910	08-02-2015 22:10	C
2223	111213	07-02-2015 11:48	C
2425	678910	08-02-2015 22:10	C
2526	111213	07-02-2015 11:56	C
9101	111213	07-02-2015 11:02	P
2627	678910	08-02-2015 22:18	C
2728	12345	08-02-2015 01:35	C
2829	111213	07-02-2015 12:05	C
2930	12345	08-02-2015 01:50	C

The variable has two components.

1) It will assign a text "P" to the first TR (according to Time) under a fixed IN

2) If TR are same then it will assign "P" to the first CN.

Rest all will be assigned "C"

Hope this helps.

Regards,

Amit

[amitrathi239]

Hi,

use this.

=If(First([CN]) In Report=[CN] Or (Last([CN]) In Report=[CN])) Then "P" Else "C"

Amit