Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

handling alpha numeric data in a column

Hi All,   Would like have if average of % values as % and average of numbers as numbers in a matrix table, I have created matrix visula but in vain the % values are not as %  but avg of numbers are...
Need Help
  • S184019's avatar
    S184019
    7 years ago

    Anonymous

     

    Hey, 

     

    Perhaps formatting could occur with a minor modification to the formula like this: 

     

    if('Table'[Field] <=1, FORMAT('Table'[Field],"##.##%"), FORMAT('Table'[Field],"General Number"))

     

    This is also true if you wanted to use an if (conditions to average), summarize table, (conditions not to summarize)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, Thanks for your reply.

This format will apply also if the column has numbers without %. In my result column for example the % values as 0.14, 0.95... and also with numbers example 12, 250...

I want to bring all these numebers as average in Matric table with if the numbers are % then the avg Number should show with %a and other wihout %.

S184019's avatar
S184019
Icon for Advocate III rankAdvocate III
7 years ago

Anonymous

 

Hey, 

 

Perhaps formatting could occur with a minor modification to the formula like this: 

 

if('Table'[Field] <=1, FORMAT('Table'[Field],"##.##%"), FORMAT('Table'[Field],"General Number"))

 

This is also true if you wanted to use an if (conditions to average), summarize table, (conditions not to summarize)