Doubt in expression with Null field criterion

[rafaeloneil]

Guys, good afternoon,

I have the 2 expressions below:

To add the output: = SUM ({$ <CHANNEL = {'PROPERTY CHANNEL'},>} PORTFOLIO)

To sum the output where a field is null: = SUM (if (len (trim (REGIONAL_CARTCPVEIC)) <1, PORTFOLIO))

How do I join the same expression in the 2 criteria, type:

=SUM ({$ <CHANNEL = {'PROPERTY CHANNEL'}, len (trim (REGIONAL_CARTCPVEIC)) <1) >} PORTFOLIO)

Can you help me?

[sunny_talwar]

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)

[rafaeloneil]

I used the Script option and it worked, Once again, thanks Sunny for the help !!

[Anil_Babu_Samineni]

If you got correct answer, Please close this thread by flag of correct answer

[sunny_talwar]

No problem at all, I am glad I was able to help