Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can we write following expression in set analysis:
=Count(distinct if((CR1_Jobcardclosed_Date-CR1_Jobcard_Date))<=2,CR1_Total_Unscheduled_Jc))
Plz Help......
Thanks
Sorry, I did not notice carefully, there are two fields (and you are actually trying to calculated the difference). Try:
=Count({<CR1_Total_Unscheduled_Jc={"=CR1_Jobcardclosed_Date-CR1_Jobcard_Date<=2"}>} distinct CR1_Total_Unscheduled_Jc)
Hi Try,
Count({<Distinct(CR1_Jobcardclosed_Date-CR1_Jobcard_Date)={'<2'}>}CR1_Total_Unscheduled_Jc)
Hi,
Try :
count({<CR1_Jobcardclosed_Date-CR1_Jobcard_Date<={'2'} >} distinct CR1_Total_Unscheduled_Jc)
Thanks,
AS
Hi,
Create one Field in Script === (CR1_Jobcardclosed_Date-CR1_Jobcard_Date) as Days_Interval
Count({<Days_Interval={"<2"}>} Distinct CR1_Total_Unscheduled_Jc)
Regards
Vimlesh
Hi
I tried it but it is not correct.
as suggested by vimlesh20 it is better to create a new field
or something like this
=Count({<CR1_Jobcard_Date = {">$(=CR1_Jobcard_Date ) <=$(=CR1_Jobcard_Date +2)"}>} Distinct CR1_Total_Unscheduled_Jc)
Any other solutions rather than creating field in script as suggested by vimlesh20.
Thanks
tried the above expression?
=Count({<CR1_Jobcardclosed_Date-CR1_Jobcard_Date={'<=2'}>} distinct CR1_Total_Unscheduled_Jc)
HI
I Have tried but its giving an error