Forum Discussion

neetu14's avatar
neetu14
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Calculating a new column based on 3 existing columns

I want to calculate a new percentage column based on volume but by using "ISDQ" column as filter.

 

eg - if ISDQ is true, calculate the sum of volume appeared by that filter and divide it by total volume to get a percentage and also if ISDQ is false, calculate the sum and divide it by total volume to get a percentage.

How to create 2 separate percentage columns for ISDQ = True and ISDQ = false

 

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try new column like

    column1 = if( [ISDQ] = "True", divide([volume],sumx(table,[volumes])),blank())
column2 = if( [ISDQ] = "False", divide([volume],sumx(table,[volumes])),blank())

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Try new column like

    column1 = if( [ISDQ] = "True", divide([volume],sumx(table,[volumes])),blank())
column2 = if( [ISDQ] = "False", divide([volume],sumx(table,[volumes])),blank())