iif condition

Avatar

Avatar
Validate 1
Level 1
shivaDT
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
shivaDT
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
shivaDT
Level 1

05-08-2015

Hi team,

I have the below query written, however I keep getting an error.

iif(

(

([expr1438750422]  Between 1 And  9)  And [expr1438752997] <=12

)

And

(

[expr1438750422] >0 And ([expr1438752958] <= 6)

),"Active-F","NULL")

any ideas would be great..

thanks

Shiva

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile
Linda_Stinson
Employee

08-08-2015

Hi Shiva,

  It would be helpful to see the error you are getting. I have a couple of suggestions:

Instead of using the default expr alias provided by Adobe Campaign, type in your own alias in the form of @myValue. You shouldn't need the brackets around this.

Use single quotes in your arg2 and arg2, e.g. 'Acitve-F'

Try starting with a simpler expression and building up the expression once you have that working.

Regards,

  Linda

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
shivaDT
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
shivaDT
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
shivaDT
Level 1

09-08-2015

Thanks Linda,

I have one more question :

I need help with the below statement, I trying to figure out what is wrong with it :

countdistinct(Iif(DateOnly(@sapInvoiceDate) > DateOnly(MonthsAgo(12) && DateOnly(@sapInvoiceDate) < GetDate() ),@id,0) )

Regards

Shiva