on 05-09-2008 7:54 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]
User | Count |
---|---|
9 | |
6 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.