I am trying to create table calculation for monthly targets.
Getting expression incomplete error:
${f_submission.bound_premium} = "January",358418,
${f_submission.bound_premium}= "February",256258,
${f_submission.bound_premium} = "March",294895,
${f_submission.bound_premium} = "April",293936,
${f_submission.bound_premium} = "May",270716,
${f_submission.bound_premium} = "June",275211,
${f_submission.bound_premium} = "July",284893,
${f_submission.bound_premium} = "August",269708,
${f_submission.bound_premium} = "September",268213,
${f_submission.bound_premium} = "October",274305,
${f_submission.bound_premium} = "November",209201,
${f_submission.bound_premium} = "December",209400,null
)))))))))))
Try using CASE WHEN
Example: https://support.google.com/looker-studio/answer/7020724?hl=en#zippy=%2Cin-this-article
CASE ${f_submission.bound_premium}
WHEN "January" THEN 358418
WHEN "February" THEN 256258
WHEN "March" THEN 294895
WHEN "April" THEN 293936
WHEN "May" THEN 270716
WHEN "June" THEN 275211
WHEN "July" THEN 284893
WHEN "August" THEN 269708
WHEN "September" THEN 268213
WHEN "October" THEN 274305
WHEN "November" THEN 209201
WHEN "December" THEN 209400
ELSE null
END