Need help in expression

[#1]

Hello Friends,

As I need to dispaly the text in a text box based on selection, the text color shoud change.

I tried =If(vFiscal<>1,Blue('Current View is Calendar Months'),Red('Current View is Fiscal Period')), but its showing the color code.

Regards

Chriss

[Gysbert_Wassenaar · Accepted solution]

You'll have to set the color for the text on the Font tab. Click on Color and check the option Calculated and enter the expression =if(vFiscal<>1, blue(), red()).  Your expression for the text would be =If(vFiscal<>1,'Current View is Calendar Months','Current View is Fiscal Period')

[#3]

Hi Gysbert,

Thanks a lot, you genious helped me lot.

great work.

Regards

Chriss