urgent help on expression

[#1]

Hi,

I have expression.

= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} Count)

I want to add one more condition.

- ONly Count where Success = 1.

How to do that.

[MK_QSL · Accepted solution]

= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = 1, Count))

[Anonymous]

Hi,

Try below script code.

= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"},Success = {1}>} Count)

Thanks

[#4]

Hi Manish,

I have to do 100 - expression and %.

I am trying as below but giving error:

= Num(100-(= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = -1, Count))/

count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>}  Count)),, '#.00 %')

[#5]

Hi Dhiraj,

I have to do 100 - expression and %.

I am trying as below but giving error:

= Num(100-(= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = -1, Count))/

count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>}  Count)),, '#.00 %')

[MK_QSL]

NUM(100-(count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = 1, Count))/

count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} Count)),'#,##0.00%')

[PrashantSangle]

Hi,

Why is there two ,, at end

= Num(100-(= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = -1, Count))/

count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>}  Count)) ,,

'#.00 %')

try

with single , and above solutions

Regards