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

10|10000 characters needed characters exceeded

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

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!

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

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.