Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
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)
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