Advanced data grouping

[olguita2014]

Hi,

I hope your help!!!...

I want to select a date, and then calculate sum(Cantidad_Saldo), if (sum(Cantidad_Saldo)<>0, Only show  records of the last date, nothing to show).... 

[pradosh_thakur]

If you could add some sample input and how your output should look like , it will be easier to help . Please elaborate a bit as your question is bit unclear.

[olguita2014]

• I have this data:

Date	KARHORA	MVESUFIJO	VEHCHASIS	Cantidad_Saldo
5/4/2018 00:00	12:26:15	AA	JTMZF9EV1ED022040	1
31/7/2018 00:00	16:07:08	AA	JTMZF9EV1ED022040	-1
31/7/2018 00:00	21:47:49	AA	JTMZF9EV1ED022040	1
4/2/2019 00:00	16:49:15	AA	JTMZF9EV1ED022040	-1

• I want to select a date, and it depends on that to make a calculation, example: 31/7/2018

• If I select the date 31/7/2018 then the result of the field Cantidad_Saldo must be the total sum of all the amounts less than or equal to the chosen date. Result: Sum(Cantidad_Saldo)=1.

• If the result of Sum(Cantidad_Saldo)=1, then create new field with the following data: Con Saldo, if not the following data is: Sin Saldo.

Date	KARHORA	MVESUFIJO	VEHCHASIS	Sum(Cantidad_Saldo)	Estado_Saldo
31/7/2018 00:00	21:47:49	AA	JTMZF9EV1ED022040	1	Con Saldo
5/4/2018	12:26:15	AA	JTMZF9EV1ED022040	1	Con Saldo
4/2/2019	16:49	AA	JTMZF9EV1ED022040	0	Sin Saldo