Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to use Only() function to return multiple values with comma separated?
As already suggested by Asinha, try like:
Concat( Distinct {<Medication= , Type={'$(=$(vType))'}, HospiceCharge={"<$(=$(vCharge))"} >} Medication , ',' )
try this
concat( {<Medication= , Type={'$(=$(vType))'}, HospiceCharge={"<$(=$(vCharge))"} >} Medication),',')
if you want comma separated value use concat...
concat(Fieldname,',')
only is used when we have just one output, concat combines multiple output in one cell
Hi,
This is my expression
Only( {<Medication= , Type={'$(=$(vType))'}, HospiceCharge={"<$(=$(vCharge))"} >} Medication)
I want to show multiple medication in the KPI or text and I know only() return null when there is multiple values
Is there any alternative for Only() to show multiple values?
Thank you
As already suggested by Asinha, try like:
Concat( Distinct {<Medication= , Type={'$(=$(vType))'}, HospiceCharge={"<$(=$(vCharge))"} >} Medication , ',' )
try this
concat( {<Medication= , Type={'$(=$(vType))'}, HospiceCharge={"<$(=$(vCharge))"} >} Medication),',')
Thank you,
Its working as I expected
Thank you Ashinha,
It's working now