cancel
Showing results for 
Search instead for 
Did you mean: 

Cal key fig based on Dates(key fig)

Former Member
0 Kudos
35

Hi,

I have got one Keyfigure in date formet as DD/MM/YYYY.(KEYFIG 1)

Based on this i have to define a second key fig (KEYFIG2) as below.

If KEYFIG1 is DD/MM/YYYY then the KEYFIG2 should come as YYYYSHIP.

It would be great if any of you can provide solution for this. Pls...

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I have relpied to ur another post....

Use this formula..

( ( DATE1 * 1 ) > 0 ) * ( ( DATE2 * 1 ) > 0 ) * ( DATE1 - DATE2)

Regards

SSS

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Krish,

YYYYSHIP ?? you want to append it or some other key figure??

Regards.

Former Member
0 Kudos

its another key figure

Former Member
0 Kudos

imean YYYY should be based on KEYFIG1, and appended as YYYYSHIP.

Thanks