Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

% calculation

Hi

 

I'm sure this is a fairly simple explanation but i'm having trouble doing this. Do i do this in a new measure?

 

Basically I have my data in a table which is a visualization as listed below what I want to do it add a new column in the table which is:

 

The table has been summed up by Current_AE

 

Lost_Business prem / (Lost_Business prem + Current Minimum) to give a %

 

Can anyone help?! 

 

Current_AECurrent_MinimumLost_Business_prem
a19525332840919
b21560282,840,919
c162187431946654
d15498612,840,919
Need Help
Tips and Tricks
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous 

    Are  [Lost_Business prem]  and [Current Minimum] explicit measures? If so, you can just create an additional measure, format it as %, and place it in your visual

     

    NewMeasure = DIVIDE( [Lost_Business prem],  [Lost_Business prem] + [Current Minimum])

     If they are implicit measures, create explicit ones (writing the formula).   

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous 

    Are  [Lost_Business prem]  and [Current Minimum] explicit measures? If so, you can just create an additional measure, format it as %, and place it in your visual

     

    NewMeasure = DIVIDE( [Lost_Business prem],  [Lost_Business prem] + [Current Minimum])

     If they are implicit measures, create explicit ones (writing the formula).