Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Creator II

## BLANK RECORDS

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 find the attachment to see the table.

Thanks,

1 Solution

Accepted Solutions
MVP

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))

2 Replies
MVP

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))

Creator II
Author

THANK YOU

Community Browser