how to exclude a value in textbox

[raghavsurya]

Hi All,

We currently have a situation wherein the graphs and charts in one of the tab does not have details for one of dimension value present in a list box. Hence we want to hide the value in the list box. Is there a way to do it.

Can anybody help me.

Regards,

Raghav

[#2]

Hi ,

Answer suggested by Tresesco is almost right but instead of using 2011 has hardcode you need to check the value in any of you key which doesn't have the data for future like ur key or the transaction value.. hence the formula can be

If(Len(TransactionAmount)>0,Year)

Note : TransactionAmount is just an asumption of the field.. Rest follow the steps suggested by Tresesco..

[sathishkumar_go]

HI Raghavsurya,

If i understood ur problem correctly,

then try this,

in load script itself restrict the year 2011 in year field and put alias some other name.

then in particular tab call that field in year.

Ex:

fiscal Cal:

year,

if(year <> 2011,year) as year_New

so in ur table u have 2 year fields 1 is containing 2011 and 1 is not 2011.

Regards

Sathish

[raghavsurya]

Thanks a lot for your kind help.

Regards,

Raghav