Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
How can i write set expression for below code
=count(DISTINCT if(len(GatePassDate)= 0,if(len([Repair Category])<> 0, BBND_ROs)))
regards
mahesh
Try like:
=count(DISTINCT {<GatePassDate={"=len(GatePassDate)= 0"}, [Repair Category]={"=len([Repair Category])<> 0"} >} BBND_ROs)
Hi Brother,
its showing Zero
May be this?
Count({<GatePassDate = {"=Len(GatePassDate) = 0"}, [Repair Category] -= {' ', '0','-'}>} DISTINCT BBND_ROs)
Hi Anil,
Not working
Or
Count({<GatePassDate = {"=Len(GatePassDate) = 0"}>} DISTINCT if(len([Repair Category])<> 0, BBND_ROs))
I don't think whether your condition gets any performance issue, You can use that
Move this expression to script
if(len(GatePassDate)= 0,if(len([Repair Category])<> 0, BBND_ROs)) as BBND_ROs_
Now write expression
Count(distinct BBND_ROs_)
Not working
I am checking this text object,its showing result zero.
Above my if condition showing exact count, but i want in same expression in set level.
Where are you using this formula, in a chart or text box? What is the output you are getting with your expression (without set analysis)?