Forum Discussion

Gerber's avatar
Gerber
New Member
4 years ago
Solved

Combining fields in table - Number & Percentage

Hi All

I have a requirement to show percentage of a total next to the number in a cell. (The table doesn't have a totals row so I'm not worried about that)

Is this possible?

 

 

Thanks 🙂

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Gerber , You can create a text measure like this and use

     

    measure = [meausre1] & "(" & [Percent Meausre] & ")"

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Gerber , You can create a text measure like this and use

     

    measure = [meausre1] & "(" & [Percent Meausre] & ")"

  • Gerber's avatar
    Gerber
    New Member
    4 years ago

    Thanks amitchandak for the solution. 

    I did have some weirdness with the percentage losing it's formatting when concatenating but solved it in the datasource.