This content has been marked as final.
Show 4 replies
-
Re: Doubt in expression with Null field criterion
Sunny Talwar May 12, 2017 11:55 AM (in response to Rafael Souza)May be this
Sum({$<CHANNEL = {'PROPERTY CHANNEL'}>} If(Len(Trim(REGIONAL_CARTCPVEIC)) = 0, PORTFOLIO))
or create a new field in the script like this
If(Len(Trim(REGIONAL_CARTCPVEIC)) = 0, 0, 1) as NullFlag
and then use this
Sum({$<CHANNEL = {'PROPERTY CHANNEL'}, NullFlag = {0}>} PORTFOLIO)
-
Re: Doubt in expression with Null field criterion
Rafael Souza May 15, 2017 11:20 AM (in response to Rafael Souza)I used the Script option and it worked, Once again, thanks Sunny for the help !!
-
Re: Doubt in expression with Null field criterion
Anil Babu May 16, 2017 1:26 AM (in response to Rafael Souza)If you got correct answer, Please close this thread by flag of correct answer
-
Re: Doubt in expression with Null field criterion
Sunny Talwar May 19, 2017 7:27 AM (in response to Rafael Souza)No problem at all, I am glad I was able to help
-