Doubt in edit expression

[danialier]

Hello !

In a List Box I have selected the year 2013. Then in a Text Box I want to see the previous yeat, so this is 2012. So when I select 2013 in the List Box I want the text box to show 2012.

Question: what should I put in the Edit Expression in the Text Box in order to get the 2012 ?

Thanks !

dani

[Anonymous]

If you have Year selected, the expression is simple:

=Year-1

[atafsson]

Hi,

If your field is named Year

and Year=2013

Type:

=sum(Year - 1)

Regards

Axel

[danialier]

Hi Michael,

Actually the fornula I have is:

= num(sum({<REGION={'AMS'},VENDOR={'HP'},[Calendar Year]>}UNITS)/sum({<REGION={'AMS'},[Calendar Year]>}IDC_UNITS)*100,0.0)&'%'

What I want is that when selecting the year 2013 I need the formula to provide the inputs for the previous year, so 2012. What I'm missing in the formula ?

thanks !

dani

[Anonymous · Accepted solution]

Quite a different question 🙂

Use this

[Calendar Year]={"$(=[Calendar Year]-1)"}

instead of [Calendar Year]

[danialier]

Excellent !!! that works now !!!! many Thanks Michael !!!!