Skip to Content
0
Former Member
Jun 04, 2008 at 04:39 PM

How can i write a code to get sume of value from days.

25 Views

Hi,

how can i write a code to get the sum of value of days(example 1 to 30).

This is in BPS ...

i created multi planning area and creted planning function with {keyfigure name,planning area,days}.

now i want to read all the actual values from basic planing area(basic cube) and calculate the sum of the value.if you have idea can you share the code.

ENTRIES = VARC ( 'zvardays' ). ex(zvardays like 28 days or 29 days or 30 days or 31 days)

COUNT = ENTRIES.

*Get the all the days value from actual

FOREACH PAREA = 'basic planning area'.

COUNT = 1.

DO

SUM = SUM + {amount, count} (amount is a keyfirgure value)

ENDDO.

COUNT = COUNT+1.

SUMACT = SUM.

ENDFOR.

can you correct the above code ....to read the values and sum of the those value.

Thanks...