How To Fix RSAR145 - Error in the If function: incorrect value in ARG2 or 3: '&' / '&'

SAP Error Message - Details

• Message type: E = Error

• Message class: RSAR - Data Transfer and Metadata Maintenance

• Message number: 145

• Message text: Error in the If function: incorrect value in ARG2 or 3: '&' / '&'

What causes this issue?

An invalided value was recognized when the If-function in a formula was
evaluated.
Argument 2 (IF-branch) : ,,,,'&SYST-MSGV1&'
Argument 3 (ELSE-branch): ,,'&SYST-MSGV2&'
Possibly, a numerical value with decimal points was entered with a
comma separating the decimals ( ' 9,99' ).
In order for a figure to be interpreted correctly, a period must be
used to separate the decimals ( ' 9.99' ).

System Response

The system triggered an exception CX_SY_CONVERSION_NO_NUMBER.

How to fix this error?

Correct the formula for the InfoObject.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSAR145 - Error in the If function: incorrect value in ARG2 or 3: '&' / '&' ?

  The SAP error message RSAR145 indicates that there is an issue with the IF function in a query or report, specifically related to the arguments being passed to the function. The error message suggests that the values in ARG2 or ARG3 are incorrect, which typically means that the function is not receiving the expected data types or values.
  Cause:
  
  Incorrect Data Types: The IF function expects certain data types for its arguments. If ARG2 or ARG3 are not of the expected type (e.g., string, numeric), it can lead to this error.
  Invalid Values: The values being passed to the IF function may not be valid. For example, if you are using a logical condition that evaluates to an unexpected result, it can trigger this error.
  Syntax Errors: There may be a syntax error in the way the IF function is written, such as missing parentheses or incorrect operators.
  Data Issues: The underlying data might have unexpected values (like nulls or special characters) that are causing the function to fail.
  
  Solution:
  
  Check Data Types: Ensure that the values being passed to the IF function are of the correct data type. For example, if you are comparing strings, make sure both arguments are strings.
  Validate Values: Review the values being used in the IF function. Make sure they are valid and expected. If necessary, add checks to handle unexpected values.
  Review Syntax: Double-check the syntax of the IF function. Ensure that it follows the correct format:
  IF(condition, value_if_true, value_if_false)
  
  Debugging: If possible, isolate the part of the query or report that is causing the error. You can do this by simplifying the IF function or breaking it down into smaller parts to identify where the issue lies.
  Check for Nulls: If your data can contain null values, ensure that you handle these cases appropriately within your IF function.
  
  Related Information:
  
  Documentation: Refer to the SAP documentation for the specific version you are using to understand the expected behavior of the IF function and any constraints that may apply.
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  Community Forums: Consider searching or posting on SAP community forums for additional insights from other users who may have encountered the same issue.
  
  By following these steps, you should be able to identify and resolve the cause of the RSAR145 error in your SAP environment.