Concatenate in a pivot table remains same value

[helen_pip]

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

[#2]

Try smthg like this:

=Time(RangeFractile(.5, $(=(If([Patient Admitted?]=1,[Total Wait]) & ',') & ',' & (If([ADMISSION_FLAG]='Y',CONCLUSION_WAIT_MINS) &','))

[helen_pip]

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