Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = 1, Count))
= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = 1, Count))
Hi,
Try below script code.
= count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"},Success = {1}>} Count)
Thanks
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 %')
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 %')
NUM(100-(count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} If(Success = 1, Count))/
count( {$<CtrlOnYear=,CtrlOnDay=,CtrlOnMonth=, CtrlOnDate= {"<=$(=date(vMaxDate))"}>} Count)),'#,##0.00%')
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