Assign sum to a varaiable

[Anonymous]

Hi,

What is wrong with the following:

Let vDrugs = Sum(if(Medication_Drug1>0,Medication_Drug1,0)) + Sum(if(Medication_Drug2>0,Medication_Drug2,0))

[sunny_talwar]

Are you using this in the script or the intention is to use this on the front end? And what kind of error are you getting?

[Anonymous]

The error – “error in script” (when I reload.

The intent is to sum the two columns (numeric/integer), and add them to create vDrugs. Then, present the value of vDrugs on one of the sheets.

[syukyo_zhu · Accepted solution]

Hi

try like this

Let vDrugs = 'Sum(if(Medication_Drug1>0,Medication_Drug1,0)) + Sum(if(Medication_Drug2>0,Medication_Drug2,0))';