problem in null values

[Mita]

Hi All,
I am taking the data from two Materilised fact views.I got the below data in the report.
both are same but 1st row don't have a date and 2nd record is having the date .For this my amount is coming as double.
How can I make it as one row.I tried with date is not null but there are some cases where date is null and we need the records.


CH   24111     D               Receivables   5307.49
CH   24111     D   01-04-16    Receivables   5307.49

[FabianGaussling]

Hi,

why don't you use a filter to remove the rows where this date-column is null?

BR

Fabian

[AnalyticsWithJay]

Hi All,
I am taking the data from two Materilised fact views.I got the below data in the report.
both are same but 1st row don't have a date and 2nd record is having the date .For this my amount is coming as double.
How can I make it as one row.I tried with date is not null but there are some cases where date is null and we need the records.


CH   24111     D               Receivables   5307.49
CH   24111     D   01-04-16    Receivables   5307.49

Is substituting a value when the date is null an option? And if so, what should the value be? As long as the values are the same it could group properly. You just need to figure out the requirement for setting the dates to the same value (eg: max, min, etc).

Your other option would be to take date out of the data container. If you want to show details you could have users drill to details.

Your other option is to take the date out of the query.