Valid Email Check

[nsandee]

Hello All,

We have a dimension object " Customer Email Address" and based on " Customer Email Address", we have created a variable called "Email check".

Email Check:

=========

=If(IsNull([Customer Email Address]);"NE";If(Match([Customer Email Address];"*@??*.*") And Not ([Customer Email Address]

InList ("xxx@xxx.com";"test@test.com";"null@null.com";"noemail@noemail.com";"email@email.com"; "none@none.com";"unknown@unknown.com";"na@na.com";"noemail@available.com";".COMHOME";".COMWORK";

".NETWORK";".EDUWORK";".COM_";".NET_";".NETHOME";".NETOTHER";"@HOME";"@WORK";"@EMAIL.COM";

"@NONE.COM";"@N.COM";"@NA.COM";"NONE@";"@REFUSED.COM";"NOEMAIL@";"@.";".@";"'...'";"NA@";

"EMAIL@";"O@";"O@" ));"VE";"IE"))

Now, Based on "Email Check", we have created "Valid Emails".

Valid EMails:

=========

=[Total]Where([Email Check]="VE")  ----------> Total = Count(Full VIN)--->  Full Vin is a direct dimension object.

If there are no values in the measure object " Valid Emails", then by default 0 should be displayed. How can we do it?

Best Regards

Sandy

[abhilash_kumar]

Hi Sandy,

This does not look like a question related to CR. If this is related to WebI, please repost to the WebI space.

-Abhilash