RobinNeeves

Calculation

Discussion created by RobinNeeves on Sep 19, 2016
Latest reply on Oct 11, 2016 by PeterDoern

Can you please help, I have created the following calculation

 

Case(

 

IsEmpty ( ContractorName ) ;

 

TrafalgarFirePreventionLtd::CompanyAddress1 & "¶" &

Case(not IsEmpty (TrafalgarFirePreventionLtd::CompanyAddress2) ;TrafalgarFirePreventionLtd::CompanyAddress2 & "¶") &

Case(not IsEmpty (TrafalgarFirePreventionLtd::CompanyAddress3) ;TrafalgarFirePreventionLtd::CompanyAddress3 & "¶") &

Case(not IsEmpty (TrafalgarFirePreventionLtd::CompanyAddressCounty) ;TrafalgarFirePreventionLtd::CompanyAddressCounty  &",") & " " &

Case(not IsEmpty (TrafalgarFirePreventionLtd::CompanyAddressPostCode) ;TrafalgarFirePreventionLtd::CompanyAddressPostCode;

 

ContractorName & "¶" &

Case (not IsEmpty (ContractorAddressStreet1) ;ContractorAddressStreet1 & "¶") &

Case (not IsEmpty (ContractorAddressStreet2) ;ContractorAddressStreet2 & "¶") &

Case (not IsEmpty (ContractorAddressTown) ;ContractorAddressTown & "¶") &

Case (not IsEmpty (ContractorAddressCity) ;ContractorAddressCity & "¶") &

Case (not IsEmpty (ContractorAddressCounty) ;ContractorAddressCounty & " " & ContractorAddressPostCode

 

 

)

 

I Get this message;

 

A number, text constant, field name or “(“ is expected here

 

I can’t see what I am doing wrong

 

Thank you for your help

Outcomes