How i do this sum

[#1]

I have a field in table named COMPT_SIAB this filled with date i need sum field NASCIDOS_VIVOS when date is last date in table i try this but dont work.. please i need help

SUM({$<COMPT_SIAB=MAX(COMPT_SIAB)>}NASCIDOS_VIVOS)

[ManuelRühl]

1. Make a variable: V_MAXCOMPTSIAB = MAX(COMPT_SIAB)

2. Use the variable like that:

SUM({$<COMPT_SIAB=(#V_MAXCOMPTSIAB)>}NASCIDOS_VIVOS)

i hope that works ...

[#3]

Hi,

here are an example that hopefully helps to solve your requirement.

Good luck!

Rainer

[#4]

i dont understand your question but try to check the attached file and see if it help.