In SAP Analytics Cloud advanced formulas, the SIGNFLIP option is used within a DATA() statement to reverse the sign of the source values before they are written to the target member. This is essential for financial calculations involving accounts with different accounting conventions, such as totaling income (typically stored as credit/negative values) and expense (debit/positive values) accounts. By using SIGNFLIP on income accounts, their signs are reversed, allowing them to be correctly aggregated with expense accounts to calculate metrics like Gross Profit or Net Income.

A. Unbooked: This option specifies whether to write values to target data cells that have no existing data. It does not perform any mathematical operation like sign reversal.

B. Append: This is a general data loading concept, not a specific configuration option within an advanced formula calculation step. The OVERWRITE parameter controls this behavior in a data action.

D. Aggregate To: This describes the goal of the action but is not an actual keyword or configuration option in the advanced formula syntax for handling account signs.

SAP Help Portal - SAP Analytics Cloud

Add a DATA Statement to an Advanced Formula: "You can use the SIGNFLIP keyword to reverse the sign of the source values. This is useful for financial calculations

for example

when you want to add expenses to revenues." (SAP Help Portal

SAP Analytics Cloud > Modeling > Calculating Data with Advanced Formulas for Planning).

SAP Help Portal - SAP Analytics Cloud

Advanced Formulas Keywords: This page details the syntax and usage of keywords in advanced formulas. The SIGNFLIP keyword is explicitly defined for reversing the sign of source data. The other options listed are either not keywords (Aggregate To

Append) or serve a different purpose (UNBOOKED). (SAP Help Portal

SAP Analytics Cloud > Modeling > Calculating Data with Advanced Formulas for Planning).