1 Reply Latest reply: Feb 5, 2013 6:55 AM by Benoît RSS

    How To Display Current month values zero,

    962252
      Hi All,

      I have Report Like This Month name and amount and balance. in this report I apply filter like current year. That is working fine when data is available. My requirement like this

      In my application Present month data is not there in that place I want display zeros.

      Ex:Month_name amount blance
      Jan 10000 5000
      Feb 0 0

      Any Help......
        • 1. Re: How To Display Current month values zero,
          Benoît
          Hi,

          to display Month without data, you must change your RPD by adding a Left Join between your time dimension and your fact table or add a left join directly in your fact source (left join between time and fact).
          After you could work on your measure and add formula to display 0 when there is no value.

          Regards,

          Benoit