Sum Of Two different type values in Measure

Hi All,

I am having problem with sum of two different type values .

example : i have address_type like  current and former i need to calculate both address type sum value as result .

but when i do sum of current address type fileld i missing former adress type sum values because when i select addresstype its separate current and former.

 
  measure: Insight_Accts_current {
    type: number
    sql: ${Insight_Active_CA} + ${Insight_Settled_CA} ;;
    filters: [address_type: "current"]
    sql_distinct_key: ${tran_key} ;;
  }
  measure: Insight_Accts_former {
      type: number
      sql: ${Insight_Active_FA} + ${Insight_Settled_FA} ;;
      filters: [address_type: "former"]
    sql_distinct_key: ${tran_key} ;;
    }

here i am adding total sum but i am not getting total sum for current and former 

because if address type current former will be set ‘0’ and if address type former current will be set 0 like that i missing the total sum 

i need both current and former total sum in this below measure 

 measure: Insight_Accts {
    type: number
    sql: ${Insight_Accts_current} + ${Insight_Accts_former};;
  } 

053d008a-04f6-4749-a9c1-232a6dcfa5f0.png

above example i pivot the address type so i get the result like above  screenshot  but  i need total sum of 8 +(-368) -360 as result.

so please any one help me out to achieve this result 

0 2 1,669
2 REPLIES 2

adnanjmi
Participant I

Well I would suggest you to use table calculations to sum both the measures . Let me know if you want any help creating the table calculation

if i use the table calculations i am not getting exact address type sum value ,

because current address values coming separate row and former address values coming separate row in same row we not having both the values.

Top Labels in this Space
Top Solution Authors