Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all this works
- as Classification = Clinical - will not change no matter what Classification is chosen by the user.
(Sum({$<Classification={'Clinical'}>}DurMins))/Sum({1}AvailMins)
This expression is better because if the week has 2 months - it will still calculate correctly.
if
(Classification = 'Clinical',((sum({$<WeekNum = p(WeekNum), Date_Fin_Month = >}DurMins))/(sum({$<WeekNum = p(WeekNum), Date_Fin_Month = >}AvailMins))))
However, a user needs to make a selection of Clinical.
I would like to make it that a User did not need to select Classification = Clinical but always stays as Clinical.
I have tried combining the two expresssions but it is hard and I end up with commas and brackets left over!
How could I modify the if statement???
Jo
Hi Josephine,
Something like below,
If(Classification = 'Clinical' or Classification <> 'Clinical' ,
Sum({$<WeekNum = p(WeekNum), Date_Fin_Month = >}DurMins) / Sum({$<WeekNum = p(WeekNum),
Date_Fin_Month =>}AvailMins))
Thanks Tamil.. still need to choose Clinical to be correct
Hi Josephine,
have a variable like vClassification = if(getselectedcount(classification)=1 and getcurrentselections(classification)<>'Classification: Clinical', only(classification), 'Clinical')
and refer the variable in set analysis as below,
(Classification = {$(vClassification },((sum({$<WeekNum = p(WeekNum),Date_Fin_Month = >}DurMins))/(sum({$<WeekNum = p(WeekNum),Date_Fin_Month = >}AvailMins))))
Warm Regards,
Karthikeyan.
Hi,
try after including Classification='Clinical' in your set analysis.
You dont required if statement.
try like
((sum({$<WeekNum = p(WeekNum),Classification={'Clinical'}, Date_Fin_Month = >}DurMins))/(sum({$<WeekNum = p(WeekNum), Classification={'Clinical'},Date_Fin_Month = >}AvailMins)))
Regards
Thank you Max Dreamer - it worked.
so if I try and understand it ...
(
(sum({$<WeekNum),Classification={'Clinical'}, Month= >}DurMins))
/
(sum({$<WeekNum), Classification={'Clinical'},Month = >}AvailMins))
)
Welcome