Using Sum(Case) with Condition

Have following:

Code:

---

sum(case when convert(varchar(10),i.date, 112) >= convert(varchar(10), @DateFromCurrMonth, 112) and convert(varchar(10), i.date, 112) < convert(varchar(10), @DateToCurrMonth, 112)
                  then cast(i.net as decimal(15, 2))
                  else 0
                end) as netqtythismonth,

---

Now I need to expand as follows:

If date criteria is met (being within from / to date) need to do additional check and operation:

Code:

---

if i.mode = 'J' and p.petroEXcode = 'Y2'THEN convert(decimal(15,2),i.net) ELSE convert(decimal(15,2),i.net) * 42 END) as netqtythismonth

---

Not sure how to code this. Thank you.

You can add additional condition with AND operator in WHEN clause

WHEN coniditon_a AND condition_b

I need something like this but I am not able to construct my statement. If within date range, I need to do an "if else" test as per below:

Code:

---

sum(case when convert(varchar(10), i.date, 112) >= convert(varchar(10), @DateFromCurrMonth, 112) and convert(varchar(10), i.date, 112) < convert(varchar(10), @DateToCurrMonth, 112)
then

if i.mode = 'J' and p.petroEXcode = 'Y2'THEN convert(decimal(15,2),i.net)

else convert(decimal(15,2),i.net) * 42 END)

as      netqtythismonth

---