{zamt,1,2}*0

[Former Member]

Hi Friends,

I would some help understanding what this fox statement means:

if zperiod=2.

{zamt,1,2}={zamt,1,2}*0.

endif.

Does {zamt,1,2}*0 mean setting the keyfigure value to 0 for the selection in the curly brackets?

regards

Sanjay

[Former Member · Accepted solution]

hi

Yes it is nothing but making keyfigure values zero. i.e. it is equivalent to deleting a record. (ur statement says that If period=2 then delete the record)

also can write as zamt=0

tx

srin

[Former Member · Accepted solution]

Hi Srin,

But if assigning a 0 to the kf, the record is still exist or this whole record is deleted?

Could you kindly clarify. I am a little confused about the deletion and setting the kf value to 0.

Thanks

Sanjay

[Former Member · Accepted solution]

Hi Sanjay,

If you assign 0 value to the KF the record will still be there.

In BPS the record is never deleted but always, a change record is inserted in the Infocube for the differential value.

e.g. If initially you had a record as

Period 1, zamt = 10

and if in the layout/through FOX you change this value to 0, an additional record will be inserted in the cube with values

Period 1, zamt = -10

As a result the net result will be 0

hope it helps

[Former Member · Accepted solution]

hi

if ur zamt represents all keyfigures then the record will be deleted

if ur zamt represent/assigned any particular keyfigure then only that keyfigure value will be zero and the record will not be deleted.

eg: if u have 2 keyfigures : 0amount, 0quantity

u hv declared

data zamt type keyfigurename

and if u make zamt=0 then the record will be deleted

next eg:

if u hv 2 keyfigures: 0amount,0quantity

u hv declared zamt='0amount'

then only 0amount keyfigure value will be 0

note: if u hv only one keyfigure then there is no problem the record will be deleted.

tx

srin

[Former Member]

This sentenc, you are multiplying the key figure zamt by zero. When you execute the function, the key figure will be set to zero.

Ravi Thothadri

[Former Member]

Hi Sanjay,

Yes, {zamt,1,2}*0 mean setting the keyfigure value to 0.

To understand more on formulas you can always press the F1 key in the Formula editor and learn more on the syntax for Formulas.

The below link may also help

http://help.sap.com/saphelp_sem60/helpdata/en/d3/8057f830a911d4b2be0050dadfb23f/frameset.htm

Hope it helps