Hi,
I have a spreadsheet with the following formula
=IF(K13=1,1,0)+IF(K15=1,1,0)+IF(K17=1,1,0)+IF(K18=1,1,0)+K14+K16
K13, K15, K17, K18, are all yes or no selection fields and K14and K16 are numerical values
The formula basically adds a value of 1 each time a yes is selected to the combined values of all the fields.
I want to replicate this with a custom field and a formula in NetSuite, so far I have the below, it doesn't error but it also doesn't produce any result, field relationship to excel formula below.
K13(custrecord_acsc_aaweb_jaws_req)
K15(custrecord_acsc_aaweb_nvda_req)
K17(custrecord_acsc_aaweb_vo_req)
K18(custrecord_acsc_aaweb_sn_req)
K14(custrecord_acsc_aaweb_add_jaws_ver)
K16(custrecord_acsc_aaweb_add_nvda_ver)
(CASE WHEN {custrecord_acsc_aaweb_jaws_req} = 'Yes' then {custrecord_acsc_aaweb_add_jaws_ver}+1 END)+ (CASE WHEN {custrecord_acsc_aaweb_jaws_req} = 'No' then +0 END)+ (CASE WHEN {custrecord_acsc_aaweb_nvda_req} = 'Yes' then {custrecord_acsc_aaweb_add_nvda_ver}+1 END)+ (CASE WHEN {custrecord_acsc_aaweb_nvda_req} = 'No' then +0 END) + (CASE WHEN {custrecord_acsc_aaweb_vo_req} = 'Yes' then +1 END)+ (CASE WHEN {custrecord_acsc_aaweb_vo_req} = 'No' then +0 END) + (CASE WHEN {custrecord_acsc_aaweb_sn_req} = 'Yes' then +1 END) + (CASE WHEN {custrecord_acsc_aaweb_sn_req} = 'No' then +0 END)Is this possible or do I need to come at this from a different route?