iif condition | Community
Skip to main content
shivaDT
shivaDT
Level 2
August 6, 2015
Solved

iif condition

  • August 6, 2015
  • 2 replies
  • 2639 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Linda_Stinson

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

2 replies

Linda_Stinson
Adobe Employee
Linda_StinsonAdobe EmployeeAccepted solution
Adobe Employee
August 8, 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

shivaDT
shivaDTAuthor
Level 2
August 9, 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

Terms & ConditionsAccessibility statement

Loading footer...