Introduction

DATA() = 0 sets only booked cells to zero and does not affect unbooked cells.

On the other hand, DATA() = 0 + 0 (Calculation result) sets all cells within the calculation scope to zero.

Example

Dimension

DateEntityProduct

Calculation scope

Date = “202410”, “202411”, “202412”Entity = “US”Product = “Product_01”, “Product_02”, “Product_03”

Case 1: Booked Data

Calculation scope: Booked data

Advanced Formulas script

MEMBERSET [d/Date] = (“202410”, “202411”, “202412”)
MEMBERSET [d/Entity] = “US”
MEMBERSET [d/Product] = (“Product_01”, “Product_02”, “Product_03”)

DATA() = 0

Calculated Result: The value of the booked cell has been changed to zero.

Case 2: Unbooked Data

Calculation scope: Unbooked data

Advanced Formulas script

MEMBERSET [d/Date] = (“202410”, “202411”, “202412”)
MEMBERSET [d/Entity] = “US”
MEMBERSET [d/Product] = (“Product_01”, “Product_02”, “Product_03”)

DATA() = 0

Calculated Result: The unbooked cell is not changed to zero.

Case 3: Booked + Unbooked Data

Calculation scope: Booked + Unbooked data

Advanced Formulas script

MEMBERSET [d/Date] = (“202410”, “202411”, “202412”)
MEMBERSET [d/Entity] = “US”
MEMBERSET [d/Product] = (“Product_01”, “Product_02”, “Product_03”)

DATA() = 0

Calculated Result: The value of the booked cell has been changed to zero, and the unbooked cell is not changed to zero.

Case 4 : Booked + Unbooked Data

DATA() = 0+0 (or 0-0)

Calculation scope: Booked + Unbooked data

Advanced Formulas script

MEMBERSET [d/Date] = (“202410”, “202411”, “202412”)
MEMBERSET [d/Entity] = “US”
MEMBERSET [d/Product] = (“Product_01”, “Product_02”, “Product_03”)

DATA() = 0 + 0

Calculated Result: The value of the booked and unbooked cell has been changed to zero.

Moonjun

IntroductionDATA() = 0 sets only booked cells to zero and does not affect unbooked cells. On the other hand, DATA() = 0 + 0 (Calculation result) sets all cells within the calculation scope to zero.ExampleDimensionDateEntityProductCalculation scopeDate = “202410”, “202411”, “202412”Entity = “US”Product = “Product_01”, “Product_02”, “Product_03″Case 1: Booked DataCalculation scope: Booked data Advanced Formulas script MEMBERSET [d/Date] = (“202410”, “202411”, “202412”)
MEMBERSET [d/Entity] = “US”
MEMBERSET [d/Product] = (“Product_01”, “Product_02”, “Product_03”)

DATA() = 0 Calculated Result: The value of the booked cell has been changed to zero. Case 2: Unbooked DataCalculation scope: Unbooked data Advanced Formulas script MEMBERSET [d/Date] = (“202410”, “202411”, “202412”)
MEMBERSET [d/Entity] = “US”
MEMBERSET [d/Product] = (“Product_01”, “Product_02”, “Product_03”)

DATA() = 0 Calculated Result: The unbooked cell is not changed to zero. Case 3: Booked + Unbooked DataCalculation scope: Booked + Unbooked data Advanced Formulas script MEMBERSET [d/Date] = (“202410”, “202411”, “202412”)
MEMBERSET [d/Entity] = “US”
MEMBERSET [d/Product] = (“Product_01”, “Product_02”, “Product_03”)

DATA() = 0 Calculated Result: The value of the booked cell has been changed to zero, and the unbooked cell is not changed to zero. Case 4 : Booked + Unbooked DataDATA() = 0+0 (or 0-0)Calculation scope: Booked + Unbooked data Advanced Formulas script MEMBERSET [d/Date] = (“202410”, “202411”, “202412”)
MEMBERSET [d/Entity] = “US”
MEMBERSET [d/Product] = (“Product_01”, “Product_02”, “Product_03”)

DATA() = 0 + 0 Calculated Result: The value of the booked and unbooked cell has been changed to zero. Moonjun Read More Technology Blogs by SAP articles

#SAP

#SAPTechnologyblog