Hello,

Cannot limit to single row since this is a Matrix. The filed Activity has the values: Absence, Training, Maintenance,Management, Support as column names and amount of hours as the...

Hello,

Thank you for your suggestions. Have more than one row showing the percentages.

Also have tried your formula to no avail.

Many thanks

Hi,

Thanks for your reply. With no formatting the Expression gives a value of zero.

many thanks

Hello,

Thank you for your reply however I am still getting the incorrect data.

Assume X = FormatPercent Expression

The Matrix looks like this:

TEAM WEEKCOMMENCING ACTIVITY (Absence, Maintenance...)...