What's wrong with this formula?

[kevnatajax]

I'm using CR7 on foxpro 2.5 dbf and trying to copy this formula and change month = 2. the formula below works for month = 1 but doesn't work for any other months. (data exist in other months) All formulas are in the Detail section.

if (tonumber({Clmanal.MONTH})=1 and (((ToNumber ({Clmanal.CODE}) >=1200) and (ToNumber ({Clmanal.CODE})<=1299)))) then {Clmanal.TOTalPD}

 

[Ngolem]

too many brackets...this should work

if tonumber({Clmanal.MONTH})= 1 and
toNumber({Clmanal.CODE}) >= 1200 and
toNumber({Clmanal.CODE}) <= 1299 then {Clmanal.TOTalPD}

Jim Broadbent

 

[mbarron]

Or
if tonumber({Clmanal.MONTH})= 1 and
toNumber({Clmanal.CODE}) in 1200 to 1299
then {Clmanal.TOTalPD}
Mike

 

[kevnatajax]

No it didn't work. I still get 00's instead of amounts in database. Any other suggestions?

 

[Ngolem]

you are repeating your posts....please don't do this

You probably have nulls in your database...either that or you are not showing the WHOLE formula...rather just the part that you think is important.

try this

if not isnull({Clmanal.MONTH} and
not isnull({Clmanal.CODE}) and
tonumber({Clmanal.MONTH})= 1 and
toNumber({Clmanal.CODE}) >= 1200 and
toNumber({Clmanal.CODE}) <= 1299 then
{Clmanal.TOTalPD}
else
0.00; //you should assign an else condition

make sure you do the isnull tests in this order...it is important that they be done first. Jim Broadbent

 

[kevnatajax]

I have another question on a formula selecting dates and if it equal a year to put text in it. I'm trying to create duration of a claims policy. This is not working. Can someone help me?

select Year(CurrentDate)-{Clmincr.CIISSYEAR}
case <=1:
&quot;Duration 1&quot;
case = 2:
&quot;Duration 2&quot;
case = 3:
&quot;Duration 3&quot;
case = 4:
&quot;Duration 4&quot;
case = 5:
&quot;Duration 5&quot;
case = 6:
&quot;Duration 6&quot;
case = 7:
&quot;Duration 7&quot;
case = 8:
&quot;Duration 8&quot;
case = 9:
&quot;Duration 9&quot;
case = 10:
&quot;Duration 10&quot;
case = 11:
&quot;Duration 11&quot;
case = 12:
&quot;Duration 12&quot;

Thank you

Renata