Displaying No Dimensions for No data

[Anonymous]

Please find the attached application , there is no data for 29th feb , I don't want to see any data , how do I fix the dimensions.

Thanks

[sunny_talwar]

There are multiple objects in you application, which one are you talking about?

[rubenmarin · Accepted solution]

Hi, the last 2 columns will print something when the result is zero, try to set it to null() when there is no data.

One way to do that is enclosing the expressions between an 'If' to check the dates:

If(ServiceTimeSeries.Date>='$(=Date(vStartDate))' and ServiceTimeSeries.Date<='$(=Date(vEndDate))',

  Your CurrentExpression

)