Line Script

[pgalvezt]

Hi, I have different phases in my formulas. but this particular is not running.

if((sum(Date)>=181  And  sum(Date)<=210) Or num(Field1) <> 8,Dual('Phase7',8)

Thanks

[#2]

Can you please try ths

if((sum(Date)>=181  And  sum(Date)<=210),If( num(Field1) <> 8,Dual('Phase7',8)))

[ericcosmai]

Hi.

Looking to this formula... is without a parentheses at the end.

Hope it helps.

Regards.

[pgalvezt]

Is not working.

I tried change it for this: but still not working.

if

((sum(Date)>=181 And sum(Date)<=210) And Field1 = 'V',Dual('181-210 Días',8)

Thanks

[ericcosmai]

Can you send any sample application... Only looking... it seems strange... because have this field called Date... I'm not sure if you can make a Sum() on this field without a treatment...

Regards..

[pgalvezt]

Date is formated like num. Dont worry for that date because in the other lines works fine. I think the problem is in Or -And.

[ericcosmai]

I think you can try put the else sentence like a null value... like this: '<empty>'

Look if it solves:

if((sum(Date)>=181 And sum(Date)<=210) And Field1 = 'V',
       Dual('181-210 Días',8)
,
     ''
)

Hope it works. Regards.

[ericcosmai]

So?

It works?

Regards.

[chematos · Accepted solution]

if

(

     (

      sum(Date)>=181 And sum(Date)<=210

     )

           And Field1 = 'V',

     Dual('181-210 Días',8)

)