Skip to Content

Attribute as a key figure calculation not working

Hi

I am trying to calculate a key figure which is a difference between two dates.

KF:

OTD1@REQUEST=AVG(OTD1@PERORDITEM)

OTD1@PERORDITEM=Date2-Date1.  Date2 and Date1 are attributes of the same master data type..

I am not able to get an output when I try to display OTD1 through the excel view.  OTD1 is defined as "attribute as a key figure" with The Time Reference Attribute being "Date1".

Any insight would be appreciated.

Thanks

Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 14, 2015 at 02:38 PM

    Hi Krishna

    maybe you can post the exact way how you calculate your formula ?

    and can you see your date's in excel? as KF or as MD ?

    Irmi

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Irmi

      OTD111 is defined as an attribute as a KF.  The data type is decimal.  Basically what the calculation does is compute the time difference between 2 dates at PERORDITEM level and average it at a REQUEST level.  Date1 and Date2 are attributes of datatype "TIMESTAMP".  No value is displayed for OTD111 when I try to view them in the Excel view.  There might be some records where "TS8CUSTOMERACCEPT" might have a null value. 

      Thanks

      Krishna