Dual Summarising Date/Time data

[jhowardcarter]

Hi,

I have a list of data in date/time format '11/09/2008 14:11:37' and I'd like to summarise it twice, (1) once month to date and (2) on just yesterdays data. My selection expert is set to month to date so (1) is simple. How to I apply a conditional summary to acheive (2)?

Thanks, in advance.

JC

 

[jhowardcarter]

edit - I'm summarising data related to the date/time stamp which is a numerical value (not summarising the actual date time stamp)

JC

 

[lbass]

Try:

if date({table.datetime}) = currentdate-1 then {table.amt}

Insert a sum on this formula at the group and/or report level.

You are in the wrong forum. Questions like this should be posted in forum149 or forum767.

-LB

 

[jhowardcarter]

Hi LB,

Spot on - thanks.

I'll post correctly next time.

Cheers