I am trying to develop my syntax to have two formulas in one field and based on a previous question, either or would be used to carry out the calculation.
For example:
1. Type of Meter
2. kw calculation
I have these two formulas that I would want to use depending on response on #1.
round((3.6*21.6)div${seconds1},1) applicable only if Without CT was selected
round((3.6*1.8*${factor})div${seconds1},1) applicable only if With CT was selected
How can I setup these two formulas in one field and based on type of meter selected previously that it would proceed to calculate.
Solved! Go to Solution.
if(${ctfield} = 'Without CT' and ${ctfield} != '', round((3.6*21.6)div${seconds1},1), round((3.6*1.8*${factor})div${seconds1},1) )
I added the check for blank. But this assumes there is only 2 options. If there are more you could do this so that it does nothing if it is any other choice.
if(${ctfield} = 'With CT', round((3.6*21.6)div${seconds1},1), if(${ctfield} = 'Without CT', round((3.6*1.8*${factor})div${seconds1},1) , ''))
hope that helps
if(${ctfield} = 'Without CT' and ${ctfield} != '', round((3.6*21.6)div${seconds1},1), round((3.6*1.8*${factor})div${seconds1},1) )
I added the check for blank. But this assumes there is only 2 options. If there are more you could do this so that it does nothing if it is any other choice.
if(${ctfield} = 'With CT', round((3.6*21.6)div${seconds1},1), if(${ctfield} = 'Without CT', round((3.6*1.8*${factor})div${seconds1},1) , ''))
hope that helps
Yes it did @DougBrowning.
Thank you so much!