Skip to Content
avatar image
Former Member

Scrpit logic question

Hi exprets ,

I have the abose KPIs that i want to claculate :

EXTR01 :inputed value

EXTR02:Calculated KPI which is EXTR01-0,3.

EXTR03:The cumulative value of EXTR02.

when I 've EXTRP 01 empty I have in the agregation in parent(Total month):-9,3

the cumulative value of every day of the month because EXTR01 is empty.

what Can do to have this algorithm

If EXTR01 is empty

EXTR02=(EXTR01-0,3)*0

else

EXTR02=EXTR01-0,3.

tahnk you .

regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 29, 2016 at 03:44 PM

    Not 100% clear but:

    *WHEN ACCOUNT
    *IS EXTR01
    *REC(EXPRESSION=(%VALUE%==0) ? 0 : %VALUE%-0.3, ACCOUNT=EXTR02)
    *ENDWHEN

    Add comment
    10|10000 characters needed characters exceeded

    • Member formulas are calculated AFTER aggregation!

      Do you understand this sentence?

      And your sample is not clear: add the line with the desired result!

      Plus - explain the formula in the sample!

  • avatar image
    Former Member
    Jan 05, 2017 at 11:52 AM
    sample.png

    Hi Vadim ,

    thanks for your help , I know that member formulas are calculated after aggregation , that's why I need to use member formula and not script logic..

    Here is the real example and the real formula

    I'm asking if for example the denominator is 0 or <0 the result of EXTR07 is 0.i'm just asking if its possible or not.

    regards.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2017 at 12:09 PM

    I am not able to understand your report logic completely, but you can always use IIF in member formula to test value:

    =IIF([EXTRxx]<0.3,...,...)

    Add comment
    10|10000 characters needed characters exceeded