string beside expression

[#1]

hi,

i want to show  string "working day" beside this code on the caption of a pivot table:

=Count (Distinct{ <[F Sr Net Sales Amount]={">=0"}>}[Full Date])

is it possible?

[tresesco · Accepted solution]

Use '&' symbol to concat a string, like:

=Count (Distinct{ <[F Sr Net Sales Amount]={">=0"}>}[Full Date]) & 'working day'

[ashfaq_haseeb]

Yo can ttryyr like this

= 'working day' &Count (Distinct{ <[F Sr Net Sales Amount]={">=0"}>}[Full Date])

Regards

ASHFAQ

[israrkhan]

tresesco said..will work

but this as well, if you wana show on start

= 'working day ' & (Count (Distinct{ <[F Sr Net Sales Amount]={">=0"}>}[Full Date]) )

[cheburashka]

Hi mana azizi

Don't forget to mark your discussion as answered.

,Thanks