Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
I used the Script option and it worked, Once again, thanks Sunny for the help !!
If you got correct answer, Please close this thread by flag of correct answer
No problem at all, I am glad I was able to help