In a Main Line = No saved search I want to use {am...
# generald
depthless
01/21/2019, 2:40 PMIn a Main Line = No saved search I want to use {amount} as the result if the Description of the Discount Item after it contains "Shipping" and {netamount} if it doesn't. Would that be possible with some sort of CASE statement? I don't know how to make the CASE statement look at the Description of the discount...
d
daniel_w
01/21/2019, 3:27 PMis the discount entered as a line item? Could use this if so...
CASE WHEN {memo} %like% 'Shipping' then {amount} else {netamount} end
daniel_w
01/21/2019, 4:22 PM@depthless if your question below is related to this...getting a formula to mimic 'Item on Any Line' would be pretty difficult. Maybe if you posted a screenshot of the data and what you want it to look like there is another means to get there
d
depthless
01/21/2019, 4:23 PMWill do, need a few
depthless
01/21/2019, 5:11 PMCASE WHEN {transaction.custbody_customer_type.id} = 18 AND {transaction.name.id} = 83725 THEN {transaction.netamount}*1.31 ELSE {transaction.netamount} END
So this returns the Net Amount on the Assembly item
depthless
01/21/2019, 5:12 PMbut i don't want the net amount if the Discount Item that comes after the Assembly has "Shipping" in the Description
depthless
01/21/2019, 5:25 PM@daniel_w i can't do the CASE you mentioned above because i'm not returning the discount item, i'm only returning the assembly item
d
daniel_w
01/21/2019, 5:38 PMare you still looking to see the same order if there is a discount item with 'Shipping' in the description, and subtract out the discount amount from netamount?
Or do you want the entire orders with the 'Shipping' discount item to be excluded?
daniel_w
01/21/2019, 5:59 PMis the "*1.13" part to show the amount before a discount is applied?
d
depthless
01/21/2019, 6:20 PMi guess i'd like to exclude entire orders with the shipping discount item
d
daniel_w
01/21/2019, 8:05 PMlooks like you're using an item search and joining to transactions, see if you get anything for {transaction.discountamount}. If that gives you the discounted $$ then you could back into it and an exclude anything where {transaction.discountamount} > 0. Otherwise a transaction search would be much easier to exclude the entire order through a summary criteria filter which would use a similar formula to above....(CASE WHEN {memo} %LIKE% 'Shipping' THEN 1 ELSE 0 END ) is equal to 0
d
depthless
01/21/2019, 8:42 PM.discountamount looks helpful
2 Views