this type of select would answer my problems but cant customize with current query builder...
Sum(IF(year(salesorders.orderdate) = '2017', salesorders.amount, 0.00)) AS `2017`

i have created two serverconnect query actions once that pulls current year sales data and one that pulls 2017 data, i need to show a calculation for my user of there progress to a % higher then 2017 vs 2018 total.

I am outputting the sales data via a group by variable by product lines. the keys are the same in both repeats, but then I don't know how to access the value from the other repeat based on the current key and use a value to do the calculation in the current_year repeat...

Hi Carlin,

This is not the best SQL statement to do such computations .. you are having an IF within a SUM. Usually you just do a SUM and filter in the WHERE statement by year ...

Anyway in the current Database Connector this is not possible, but we are working on a new major version 2 that will have totally overhauled visual query builder that supports aggregate functions like SUM

Greetings,
George

What is the status of the "new major version 2" that will allow us to do functions such as SUM?

Hello Mike,
Sum as well as other functions are already available in Database Connector 2:

Well.....that sucks!!!! I just bought the original a few months ago!

@Teodor,
I can never chat with anyone to see if there is a way I can get a substantial discount. This is a functionality I need but don't think DMXZone giving me a discount is out of the question. How can I work this out?