This discussion is archived
1 Reply Latest reply: Feb 5, 2013 4:55 AM by Benoît RSS

How To Display Current month values zero,

962252 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points