why newly added dimension with edit expression made records duplicate

[#1]

Hi all,

I have a straight table below. 'Vacant Days' is an expression:

sum(if(Vacant_StartDate>Vacant_EndDate,' ', if(Vacant_EndDate>=vFrom and Vacant_StartDate<=vTo, if(Vacant_EndDate>vTo,(vTo-Vacant_StartDate)+1,(Vacant_EndDate-Vacant_StartDate)+1))))

Now I need to add the current property tenancy status as at variable Date vTo in the report. It is an dimension with expression:

IF(vTo>=StartDate1 and vTo<=EndDate1,TenancyStatus).

The problem is I can't make the tenancy status shown in the same row of each property, and vacant days for each property have duplicate records.  Can anyone help me with that?

(Note that except 'Tenancy Status', all other dimensions are from the same table)

.

[marcus_sommer · Accepted solution]

You need to suppress the NULL displaying - there is an option with the tab presentation for this. Helpful could also be to include those condition within a dimension - maybe: IF(vTo>=StartDate1 and vTo<=EndDate1, PMP_SEQ) - and hide there the NULL's (option by each dimension).

- Marcus

[#3]

Thanks Marcus.