BLANK RECORDS

[bhavvibudagam]

Hi,

I have used below expression in calculated dimension

=if(NUM(PDARCH_COMMON_EVENT.STREET_NUMBER)=8500 or NUM(PDARCH_COMMON_EVENT.STREET_NUMBER)=12400,'',

if(NUM(PDARCH_COMMON_EVENT.STREET_NUMBER)>0, PDARCH_COMMON_EVENT_ADDRESS,XSTREET1 &' / '& XSTREET2))

Getting blank records on Table.

I need to give the name for blank records as Stations.

Please help me to put the condition on above calculated dimension condition.

Please find the attachment to see the table.

Thanks,

[sunny_talwar · Accepted solution]

May be this:

=If(Num(PDARCH_COMMON_EVENT.STREET_NUMBER) = 8500 or Num(PDARCH_COMMON_EVENT.STREET_NUMBER) = 12400, 'Station',

If(Num(PDARCH_COMMON_EVENT.STREET_NUMBER) > 0, PDARCH_COMMON_EVENT_ADDRESS,XSTREET1 &' / '& XSTREET2))

[bhavvibudagam]

THANK YOU