Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have written the following and it returns a value of 03:06
When I add this formula to a pivot table which has month across the top, the formula remains at 03:06 for every month
=
Time(RangeFractile(.5, $(=Concat(If([Patient Admitted?]=1,[Total Wait]), ',') & ',' & Concat(If([ADMISSION_FLAG]='Y',CONCLUSION_WAIT_MINS), ','))
Could you kindly help me rewrite the formula so that it is not static and will change for every month in the pivot table
Kind Regards
Helen
Try smthg like this:
=Time(RangeFractile(.5, $(=(If([Patient Admitted?]=1,[Total Wait]) & ',') & ',' & (If([ADMISSION_FLAG]='Y',CONCLUSION_WAIT_MINS) &','))
Hello
Thank you for your reply. I have been playing with this statement for a couple of days now, and cannot seem to get it to work
The above statement unfortunatley returns a null value
Do you have any additional ideas?
Thanks
Helen