Ask Your Question

Revision history  [back]

Revision 3
Ahmed Qasid's avatar
5.8k
Ahmed Qasid
updated 2019-02-18 02:48:01 +0200

You can use SQL statement like the following two examples

n5=totalizeif(details,details.price.netValue,select case when {details.item.item.code} = 'ABC' then 1 else 0 end)
n4=totalizesql(select {details.n1}*{details.n2}+10)

Revision 2
Eldabbas's avatar
9.1k
Eldabbas
updated 2019-02-06 06:41:50 +0200

You can use SQL statement like the following two examples

 
n5=totalizeif(details,details.price.netValue,select case when {details.item.item.code} = 'ABC' then 1 else 0 end)
n4=totalizesql(select {details.n1}*{details.n2}+10)

Revision 1
Eldabbas's avatar
9.1k
Eldabbas
answered 2019-02-06 06:39:01 +0200

You can use SQL statement like the following two examples
n5=totalizeif(details,details.price.netValue,select case when {details.item.item.code} = 'ABC' then 1 else 0 end) n4=totalizesql(select {details.n1}*{details.n2}+10)

{details.n1}*{details.n2}+10)