Defaulting Nulls to 0

• bunnie

  Old Hand

  Points: 376

  More actions

  April 10, 2008 at 1:41 pm

  #189010

  Iam trying to create a report from SSAS cube.

  I've a field --- Sales.(in the report)

  I want to get 0 if the Sales are nul.

  Can any one please help me how to default NULLS to 0 in Analysis Services cube.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 10, 2008 at 1:46 pm

  #801167

  I don't know how to do it in a cube but in Reporting Services you can do:

  IIF(Fields!Field_Name.Value Is System.DBNULL.Value, 0, Fields!Field_Name.Value

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question