i think you gotta place a ' around 719?
# generall
leo
08/13/2020, 7:06 PMi think you gotta place a ' around 719?
y
Yossup
08/13/2020, 7:07 PMTried that, same issue
Yossup
08/13/2020, 7:07 PMmessage has been deleted
l
leo
08/13/2020, 7:08 PMplace the 1.2*0.65 into a parenthese
s
Synx
08/13/2020, 7:08 PMI beleive you need to END the statement
Synx
08/13/2020, 7:09 PMso just enter END at the end
l
leo
08/13/2020, 7:09 PMand that too!
leo
08/13/2020, 7:09 PMlol
y
Yossup
08/13/2020, 7:15 PMI tried those combos, still not working! very strange
Yossup
08/13/2020, 7:15 PMI get the same error..
l
leo
08/13/2020, 7:16 PMquantity is a field in the result column right?
y
Yossup
08/13/2020, 7:16 PMOh i got it! I had to put a '=' instead of the 'is'
Yossup
08/13/2020, 7:16 PMCASE WHEN {account.id} = 719 THEN {amount}/{quantity} ELSE {amount}/{quantity}/1.2*0.65 END
l
leo
08/13/2020, 7:16 PMGood job mate!
y
Yossup
08/13/2020, 7:16 PMhaha thx
k
KevinJ of Kansas
08/13/2020, 7:25 PMyou probably want to include an nullif({quantity},0)
KevinJ of Kansas
08/13/2020, 7:26 PMbecause you are doing division - if quantity is null or zero, then you can get divide by zero errors
KevinJ of Kansas
08/13/2020, 7:26 PMmight be better as
{amount}/nullif(nvl({quantity},0),0)y
Yossup
08/26/2020, 6:48 PMI have added this, good point