Skip to Content
author's profile photo Former Member
Former Member

Formula with Characteristic

Hi Gurus,

I have to create the following formula based in 2 characteristics result:

IF (DATE1+15) < (DATE2)

FORMULA=1

ELSE

FORMULA=0

ENDIF

-DATE1--


DATE2----

-


FORMULA

1--01.01.2006-01.10.2006----1

2--01.02.2006-01.25.2006----0

I Tried to create a formula but i couldnt do it because i cannot use Characteristic values.

THANKS A LOT , I REALLY APPRECIATE YOUR HELP.

REGARDS

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 01:43 PM

    Hi Marcos,

    Try with Formula Variable. You define it in KF tree (in global selection or in Columns/Rows), with right mouse click and selecting New Formula, in the left area you will find "Formula Variable", with this you can obtain formula on Characteristics.

    Ciao.

    Riccardo.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 01:46 PM

    Hi Marcos:

    You need to create formulas variables based in both Characteristics. In that way you will be able to create a normal formula (key figure) based in two characteristics.

    I hope it helps.

    Norge

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 01:43 PM

    Hi Marcos,

    Create a Formula variables for those two date characteristics . and use can use these varibles in the formula which u create to calculate IF condiction.

    IF (ForvarDATE1+15) < (ForvarDATE2)

    FORMULA=1

    ELSE

    FORMULA=0

    ENDIF

    Hope it solves ur problem.

    Assign points if useful.

    Message was edited by: San

    Add comment
    10|10000 characters needed characters exceeded