CONDITIONAL SUM

[#1]

hI folks!!

I have three tables:

Table 1: MES_BALANCE, AÑO, MES, ID

Table 2: SOCIEDAD, CUENTA, MES_BALANCE, IMP_DIARIO, ID_SOCCTA

Table 3: ID_SOCCTA, IMP_ANALITICA

I select information by selecting AÑO and MES (YEAR and MONTH)

Could I sum acumulate imp_analitica until month and year selected?

I create Table 1 exclusively to get an ID and sum it like: SUM({$<ID={'<=$(=ID)'} >} IMP_ANALITICA)

No data appears because ID is not a selected field, so I tried SUM({$<ID={'<=$(=Max(ID))'} >} IMP_ANALITICA)...

and wrong data.

Anyone can help me? I appreciate your help because I,m going crazy

Fiber9906

[#2]

It´s a very good reply!! It looks like that it works perfectly!!! I´ve been doing test since yesterday morning.... so you don´t know how appreciate your answer.

Really thank you!

Fiber9906

PS. Where did you know to do that? I don´t find these things on tutorials... (or unlles I don´t know to search for)