Expression

[upaliwije]

Hi Friends

I have created a variable for the Risk Day which is as follows

vh1=(RISK_DAY>=1 and RISK_DAY<=14)

Now I want to apply this vh1 to expression which is follows

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY=$(v1h)>}Nos)

But this expression does not show the required results. Pls correct my expression

[tresesco]

Try changing variable definition like :

vh1= '{>=1 <=14}'

[Anil_Babu_Samineni]

Yesterday, I learn this from sunny

SET vh1 = '{>=1 <=14}'

Then, Use below

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY=$(v1h)>}Nos)

[upaliwije]

Hi Anil

What I did was like this

Then the Variable look like this

Still result show is 0

Pls advise whether  what I have done is correct

[its_anandrjs]

Why not try with this

=sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY = { $( ">=1 <=14" ) } >}Nos)

Or

=sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY = { $( >=1 <=14 ) } >}Nos)

[upaliwije]

Sorry further to that there is an error mark in the expression as well

[Anil_Babu_Samineni]

May be this?

SET vh1 = '{">=1 <=14"}'

[Anil_Babu_Samineni]

Don't worry about error , That is Bug only not yet resolved

[tresesco · Accepted solution]

If you are using SET, try removing single quotes from outside and put inside like:

SET vh1 = {'>=1 <=14'} ;

[upaliwije]

Still result shown is 0