cancel
Showing results for 
Search instead for 
Did you mean: 

Help with Macro

Former Member
0 Kudos

Hi all,

I am trying to get zero values in a key figure row. It works fine as long as there is some value in the cells. When it is blank cell it doesn't show up zero there.

Any suggestions?

Thanks

Vard

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Vardev,

I am hoping you are using the macro logic correclty.

here is how I would do:

If KFF1 is my KF then my macro would be

Macro

-


Step

-


Row: KFF1=

-


0

If the cell is a null value and if the system is not replacing it with zero, then cheange your macro like this:

Macro

-


Step

-


Row: KFF1=

-


0

-


If

-


Condition (if Null)

-


IS_INITIAL(KFF1) = 1

-


Row: KFF1=

-


0

-


Endif

If the system is not replacing all values with null and you want a zero in that, check in your planning area if "Zeros allowed" is checked for that keyfigure.

Hope this helps.

Former Member
0 Kudos

Thank you for the input. I am not able to write the step,

IS_INITIAL(Row:KF1)

Once I insert the function IS_INITIAL() , how to insert the row?

Vardev

Former Member
0 Kudos

1. Drag and Drop the "Operator/function" where you can select IS_INITIAL()

2. then delete the closing brace ( leave the bracket open)

3. drag and drop "Row" from "Planning table " and select your KF.

4. In KF properties for Datasource, select "Row Attributes" ( or else you will get a dump saying GETWA_NOTASSIGNED)

5. Drag and drop the "Operator/function" and enter the following:

) = 1

If you still got questions on that, refer to IS_NITIAL syntax in [this sap help link.|http://help.sap.com/saphelp_scm50/helpdata/en/1d/310eb3d0ee11d4b2e40050da385632/frameset.htm]

Former Member
0 Kudos

Thank you very much.

Answers (0)