Skip to Content
Oct 07, 2021 at 02:43 PM

Help to write formula in Analyzer



I need help with the following: I am trying to write a formula in a Query that will later be displayed in an Analyzer report and what I am looking for is that -> When the result of the formula is 0, the report must show X, an error or something similar, we cannot put any number. Query Designer in SAP BW 7.5 does not allow characters to be typed, it only allows predefined elements to be dragged. Any suggestion? Thanks.

The formula is: ( 'FIELD_X' )==0 * NDIV((-1)) + (NOT ( FIELD_X)==0)) * FIELD_X)

-1 is beacuse we thought to show -1 when the result was 0, but we need character or error.