How to use function in Set Analysis

[kamal_sanguri]

Hi Experts,

I want to use a function in Set Analysis.

Something like this.

=sum(<Len(Comments) > {'5'}> CHARGES)

But dont know how to use it correctly.. Any help would be greatly appreciated.

Thanks,

-Kamal

[kaushiknsolanki]

Hi,

Better you create Len(Comments) as lengthOfComments as new field in script and then use the below set expression.

Sum({<lengthOfComments  = {">5"}Charges)

Regards,

Kaushik Solanki

[ramoncova06 · Accepted solution]

I agree with Kaushik in the backend changes

though if you are not able to do that then try with

=sum({< CHARGES = {"=Len(Comments) > 5"} >}CHARGES)

[maxgro]

small example

script

load

  rowno() as Id,

  floor(rand()*10) as Id2,

  floor(rand()*100) as CHARGES,

  99999 + floor(rand()*2) as  Comments

AutoGenerate 100;

chart with this expression

sum({$ <Id={"=len(Comments)>5"}>} CHARGES)

you can find more detail here

Set Analysis: syntaxes, examples