Do not create a date whem value is null

[brunolelli87]

Dears,

I'm using the following script to create a calendar, 

LET vStartDate  = num(Floor(YearStart(Today(),-4)));
LET vEndDate    = num(Floor(Today()));
LET vToday      = num(Today());
LET vYesterday  = num(Today()-1);

Calendar:
LOAD

	Date#(date($(vStartDate) + RowNo() - 1), 'DD/MM/YYYY') 				as PERI,
	QuarterName(Date#(date($(vStartDate) + RowNo() - 1), 'DD/MM/YYYY')) as QUAR

AUTOGENERATE

  $(vEndDate) - $(vStartDate) + 1;

So, I have all dates from a period of time,

After that, I'm loading some data with Dates and Values, as you can see at the table below:

It's showing R$ 0,00 because there is no value for VDAA, but the date PERI exists...

So, my question is:
How can I do not show dates (PERI) when the value of VDAA is null?

Thanks

Bruno Lelli

[chrismarlow]

Hi,

I am assuming that is a straight table where PERI is your dimension and the other 4 columns are measures.

I think it is showing values because your right 2 LOPP columns use TOTAL somehow, so for the dates (that look like weekends) you still get values. If you have a straight table with just PERI & VDAA do you have the same problem?

Cheers,

Chris.

[Taoufiq_Zarra · Accepted solution]

Maye be if VDAA is not a mesure and for pivot table you can  :

Add Calculated Dimension ...

=if(VDAA>0,PERI)

and

Suppress When Value Is Null

otherwise can you share any other information !

[brunolelli87]

Good,
Thanks!

[brunolelli87]

Hello,

Thanks for your help, 

PERI is my dimension and the other fields are expression...
I solved it using the following expression provided below: =if(VDAA>0,PERI)

Thanks for all your help,
Best regards