BFC: Cell formulas in reports

[martingebhartl]

Hello,

I wonder if it´s possible to insert a cell formula (IF formula) in a BFC Report, which has a text as a result.

Formula should look like this:

= IF (A1 > 0 and B1 = 0; "YES"; "NO")

I always get "Incorrect formula" as long as I use "YES" or "NO" as a result. As soon as I uses numbers, the formula works.

Is this a normal behaviour?

We are using SAP FC 10.0 SP09

Regards

Martin

[olga_vasilieva · Accepted solution]

Hi Martin,

According to FC10 Windows User Guide: "Note: Cell formulas do not enable you to display text. Similarly, they do not enable you to apply conditions to text."

A possible workaround is setting text in Cell Format > Data > Display for positive, negative and zero values. In your case above, you can set formula in "control" cell as = IF (B1=0; A1; -1) and set cell Display as "YES";"NO";"NO".

Best regards,

Olga

[martingebhartl · Accepted solution]

Hello Olga,

thanks for your reply!

Regards

Martin