Subject Re: how to calculate 2 records of the same column of a grid : solved
From Dirk <dirk.cardoen1@gmail.com>
Date Wed, 13 Jan 2021 11:27:14 +0100
Newsgroups dbase.getting-started

Op 12/01/2021 om 21:00 schreef Dirk:
> Goodday,
 > i am trying to calculate 2 records of the same  column as excel, make a
> sum in a calculated fields, by clicking on the grid cell
 >
> means want to know the consume of solar electricty in a certain period
 >
> i can of course use 2 colums , 2  fields : 1 begin and 1 end
 >
> but begin of column 1 day x, should be end of column end day - 15
 >
> day is date field i put the info into
 >
> so, to avoid a column i trying to find out a way as excel
 >
> thanks for a helping hand
 >
> best regards
 >
> Dirk
  Good -moring,day,evening sirs

   thanks for your usefull replies
  as mentioned = using id and date field ( will use this to have the
know    the consumption for a periode of a month or year

  to quote on a weekly or daily base i composed the following

    Function verbruik
         local Bereken, nWaardeA, nWaardeB
            Bereken =Form.Vraagbak_DataEnergie.rowset
                   nWaardeA = (Bereken.fields["eDageinde"].value)
           bereken.next(-1)                
            nWaardeB= (Bereken.fields["eDageinde"].value)
         form.veld_totverbruik.value =(( nwaardeA) -(nWaardeB))                
        Return
        ******

   your examples widen my horizon again

   take care

   regards

  Dirk