Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have the following in my dimension:
if( (Store_Latitude > vLatMin and Store_Latitude < vLatMax) and ( Store_Longitude < vLonMax and Store_Longitude > vLonMin ), Store_FullName,null())
What is does is show all the stores within a radius of a selected Postal code. Works perfect except ...
When I associate Postal Code table with Store Table and others, the results are limited to just those in the area code.Is there a way I can/should exclude Postal Code from limiting the results?
in expresion try use below
sum({<[Postal Code]=>}fieldname)
in above [Postal Code]=
used to exclude selection
hope this helps
in expresion try use below
sum({<[Postal Code]=>}fieldname)
in above [Postal Code]=
used to exclude selection
hope this helps
Thank you Sunil,
I knew it was going to come down to using set analysis; although I was hoping to do it another way. I did use what you said in a text object and it worked.
=Count({<[PostalCode_PostalCode]=> }distinct if( (Store_Latitude > vLatMin and Store_Latitude < vLatMax) and ( Store_Longitude < vLonMax and Store_Longitude > vLonMin ), Store_FullName))