Netsuite custom formula field using a CASE statement with multiple WHEN conditions returning "invalid expression", Im trying this for case like CASE WHEN THEN ELSE CASE WHEN THEN ELSE END END

You can do syntax like CASE WHEN THEN WHEN THEN ELSE END ... otherwise your problem may be that you need to wrap your inner CASE WHEN in parens ()

This is what my code looks like CASE WHEN {custrecord_tr_customer.custentitycust_tr_customer_level_apr.id} IS NOT NULL THEN {custrecord_tr_customer.custentitycust_tr_customer_level_apr} WHEN {custrecord_tr_employee.subsidiary.id} = 2 AND {custrecord_tr_project.custentity_clientpartner} IS NOT NULL AND {custrecord_tr_employee.id} != {custrecord_tr_project.custentity_clientpartner.id} THEN {custrecord_tr_project.custentity_clientpartner.id} WHEN {custrecord_tr_project.jobtype.id} = 1 AND {custrecord_tr_employee.id} = {custrecord_tr_project_executing_practice.custrecord_practicehead.id} THEN {custrecord_tr_employee.custentity_reportingmanager.id} WHEN {custrecord_tr_project.jobtype.id} = 1 AND {custrecord_tr_employee.id} != {custrecord_tr_project_executing_practice.custrecord_practicehead.id} THEN {custrecord_tr_project_executing_practice.custrecord_practicehead.id} WHEN {custrecord_tr_project.jobtype.id} = 2 AND {custrecord_tr_employee.id} != {custrecord_tr_project.custentity_deliverymanager.id} THEN {custrecord_tr_project.custentity_deliverymanager.id} WHEN {custrecord_tr_project.jobtype.id} = 2 AND {custrecord_tr_employee.id} = {custrecord_tr_project.custentity_deliverymanager.id} THEN {custrecord_tr_employee.custentity_reportingmanager.id} WHEN {custrecord_tr_project_executing_practice.id} NOT IN (402, 403, 404, 407, 192, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 469, 470) AND {custrecord_tr_project_executing_practice.custrecord_practicehead} IS NOT NULL AND {custrecord_tr_employee.id} != {custrecord_tr_project_executing_practice.custrecord_practicehead.id} THEN {custrecord_tr_project_executing_practice.custrecord_practicehead.id} ELSE CASE WHEN {custrecord_tr_project.jobtype.id} = 2 AND {custrecord_tr_employee.id} != {custrecord_tr_project.custentity_deliverymanager.id} THEN {custrecord_tr_project.custentity_deliverymanager.id} ELSE {custrecord_tr_employee.custentity_reportingmanager.id} END END

Yeah put that in the formula checker

formula checker?

in suite analytics

im using netsuite

I am aware, there is a suite analytics tab in netsuite

ok im not aware of this

If you are not using query, then your problem is likely all the multi-level joins

ya

2 dots is multi-level

ok i will try

your case when is a bit off though, as seen below

CASE
 WHEN {custrecord_tr_customer.custentitycust_tr_customer_level_apr.id} IS NOT NULL
  THEN {custrecord_tr_customer.custentitycust_tr_customer_level_apr}
 WHEN

That’s not valid. You can do “`CASE variable WHEN condition THEN whatever WHEN condition2 THEN whatever2`” but if you choose to use

CASE WHEN variable/condition THEN whatever

, you will need to follow it up with ELSE then wrap another CASE WHEN underneath, as you laid it out in your original post. This is not consistent with what you originally posted. See the difference?