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
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