Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculation Group format string expression mixing numbers and percentages help

The problem is that I want to get the Matrix and Table to recognise a figure as either a Number or a Percentage in one column rather than having to see it in 2 columns.   For example. The matrix v...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Anonymous ,

Are Act%, Tar%, Art and Tar all your columns? Why there're not Act% and Tar% in the last spreadsheet.

Best Regards,
Community Support Team _ kalyj

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi v-yanjiang-msft. I have now added a clearer spreadsheet and included links to dropbox excel and pibx file.

    Link to excel file 

    Link to PIBX 

     

    The main columns are Actual and Target. In the "Matrix" the Act% Tar% Act and Tar come from the Calculation Group "No.s or % test" and I just use the "Name" in the "Column" of the visual.
    I then went into format painter, into a column header and changed the font colour from black to white (so you could not see the column header colour) I then added 5 x text boxes just for visual display (Trend, Act%, Tar%, Act, Tar)