Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to put this in a chart title to show the Hospital group and the year that is selected and it works fine but I also want it to show if 'Hospital' is picked as a selection so either hospital or hospital group will be selected and the year and then the title should show these
I have tried all sorts of and or expressions but it doesnt seem to work
=GetFieldSelections(HospitalGroup)& ' , ' & GetFieldSelections(ReferredYYYY)
Hi Rhona,
If i understand well, if Hospital is selected you want hospital name, if not you want Hospital group selected
=if(count(distinct Hospital)=1,
GetFieldSelections(Hospital)& ' , ' & GetFieldSelections(ReferredYYYY) ,
GetFieldSelections(HospitalGroup)& ' , ' & GetFieldSelections(ReferredYYYY)
)
best regard
Chris
GetFieldSelections only returns values that are actually selected. As long as there's only one possible value you can use something like =only(HospitalGroup). Otherwise try concat(distinct HospitalGroup, ' / ')
Hi Rhona,
If i understand well, if Hospital is selected you want hospital name, if not you want Hospital group selected
=if(count(distinct Hospital)=1,
GetFieldSelections(Hospital)& ' , ' & GetFieldSelections(ReferredYYYY) ,
GetFieldSelections(HospitalGroup)& ' , ' & GetFieldSelections(ReferredYYYY)
)
best regard
Chris
thanks to all and to Chris that is great.