Tuesday, February 14, 2012

DateDiff

Hi,
I am using this formula and I want to reset (Zero) the formula on change of group and grand total it. Can't work out how to do it! Probably something really simple.
DateDiff ("s",Previous ({Order.DateReceived}) ,{Order.DateReceived})
Many ThanksYou can have two formulas,

first one will be group wise total

second one will have the entire total (grand total)|||Crystal won't allow me to summarise this field based on the time calcuation! DOH!

No comments:

Post a Comment