Display the Text value in the report column

[former_member188760]

Hi Experts,

I have an requirement like to display the specified Text value based on the condition as below.

Ex:

No of Days        Text Column

10                    Returns>3m

-10                    Expired

If the No of days > 0, then the Text column to be displayed as Return>3m and the the no days are less than 0 then the Text coumn to be display as Expired.

Can anyone suggest how to display the Text values in the report display based on the no of days calculated.

(Note:Theses No of days are calculated at run time of the report based on other 2 columns)

Thanks

[ccc_ccc]

Hi Anilkumar,

I solved similar problem with below blog , please check.

Thank you,

Nanda