Skip to Content

Grouping in Sap Crystal Reports

Hi,

Below is my formula..

if ({A_PFCHOLDINGS.POR_CURRENCY} & {A_SEC_FREECODES.FREE_CODE_41_NAME}) = ({%Valuation Currency} & {%Investment Type}) then 'Portfolio on Investments by Valuation Currency & Investment Type'

else

if({A_PFCHOLDINGS.POR_CURRENCY}&{A_SEC_FREECODES.FREE_CODE_41_NAME} & {A_SECS.COUNTRY_REF}) = ({%Valuation Currency} & {%Investment Type} & {%Country of Risk}) then 'Portfolio of Investment - Country of risk, Valuation Currency & Investment Type'


In above formula two conditions are there. Before else after else. I'm creating 2 categories. Because of else I'm getting only 1 cat at a time. How to get 2 cats at a time?

Please help me on this.

Thanks

Riaz

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 05, 2017 at 10:58 AM

    A record can only meet one condition.

    With an If then else statement as soon as a true condition is met the formula stops evaluating.

    You will need to create a second formula for the second condition if you want to display both results.

    Ian

    Add comment
    10|10000 characters needed characters exceeded