Comparative Analysis and Nulls

[ali_hijazi]

Hello

I'm using Comparative Analysis in a pivot table

my expression is as follows:

sum({<RECORD_TYPE={'profiling'},CALENDAR_DATE={"=$(=max({<RECORD_TYPE={'profiling'}>} CALENDAR_DATE))"}>} TOTAL_CPU_USAGE)

and the comparative one is as follows:

sum

  (

  {[Group 1]

  <

  FEEDER_QUALITY_LEVEL=$::FEEDER_QUALITY_LEVEL

  ,TPK=$::TPK

  ,MODULE=$::MODULE

  ,QC_THEME=$::QC_THEME

  ,RECORD_TYPE={'profiling'}

  ,CALENDAR_DATE={"=$(=max({[Group 1]<RECORD_TYPE={'profiling'}>} CALENDAR_DATE))"}

  >

  }

  TOTAL_CPU_USAGE

  )

the problem that if I select the same month and Year I don't get the same results because some records have Nulls for MODULE, and QC_THEME

so when I'm writing QC_THEME=$::QC_THEME the null is not included

Please advise

[ali_hijazi · Accepted solution]

I found the solution using union

so the comparative expression would be like follows:

sum

  (

  {[Group 1]

  <

  FEEDER_QUALITY_LEVEL=$::FEEDER_QUALITY_LEVEL

  ,TPK=$::TPK

  ,MODULE=$::MODULE

  ,QC_THEME=$::QC_THEME

  ,RECORD_TYPE={'profiling'}

  ,CALENDAR_DATE={"=$(=max({[Group 1]<RECORD_TYPE={'profiling'}>} CALENDAR_DATE))"}

  >

  }

  TOTAL_CPU_USAGE

  )

+

sum

  (

  {[Group 1]

  <

  FEEDER_QUALITY_LEVEL=$::FEEDER_QUALITY_LEVEL

  ,TPK=$::TPK

  ,MODULE=$::MODULE

  ,RECORD_TYPE={'profiling'}

  ,CALENDAR_DATE={"=$(=max({[Group 1]<RECORD_TYPE={'profiling'}>} CALENDAR_DATE))"}

  >

  }

  TOTAL_CPU_USAGE

  )

+

sum

  (

  {[Group 1]

  <

  FEEDER_QUALITY_LEVEL=$::FEEDER_QUALITY_LEVEL

  ,TPK=$::TPK

  ,QC_THEME=$::QC_THEME

  ,RECORD_TYPE={'profiling'}

  ,CALENDAR_DATE={"=$(=max({[Group 1]<RECORD_TYPE={'profiling'}>} CALENDAR_DATE))"}

  >

  }

  TOTAL_CPU_USAGE

  )

[avinashelite]

if you have got the answer please close this thread ....