Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in a diagram-table there are two fields, which should be works together. If table field largest_case is empty, Location-field should be also empty. If largest_case have a value, Loacation have a value.
Regards
Stefan
use an if statement. But this is not very clear, you need to elaborate a little.
if (len(largest_case)=0,' ',Location_field ) as Location_field
if(len(Location_Field)=0,' ',largest_case) as lagest_case
may be you looking for this.
Thanks
Sunil
if(len(trim([largest_case]))=0, '', [Location-field]) as [Location-field]