Skip to Content
0
Former Member
Nov 29, 2006 at 01:32 PM

fox formula

22 Views

hi,

I have the following problem:

My fox formula tries to save from the basic cube to transactional cube. In basic cube is this data.

Material: A

Project: B

Validto: 00.0000

Amount: 100

And

Material: A

Project: B

Validto: 10.2006

Amount: 200

The result that I want in my transactional cube is the sum of two records in a valid to 00.0000.

Material: A

Project: B

Validto: 00.0000

Amount: 300.

The entry parameter are: project : B, validto: 00.0000 and 10.2006 ( always will be tow values, 00.0000 and other)

I write the following code.

FOREACH MATERIAL, PROYECT, VALIDTO.

{0AMOUNT, MATERIAL, PROYECT,#, ZTRASACTIONAL} =

{0AMOUNT, MATERIAL, PROYECT, VALIDTO, ZBASIC}.

ENDFOR.

But the result is the amount on VALIDTO: 10.2006. (The record is overlapped and is not getting summed)

In the example the saved amount is 200 not 300 as I want.

How can I obtain the amount that I want?

I would you appreciate your help.

Thanks,

Victoria