Email check

[nsandee]

Hello All,

We have a dimension object " Customer Email Address" and based on " Customer Email Address", we have created a variable in BI Launch pad 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"))

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

Sandeep

[former_member185603]

post it in webi forum, you will get faster response.

[srinivasan_vinayagam]

This message was moderated.