Data range formula

Here are a couple of examples:

Days Variance: (integer(ShipHead.ShipDate) - integer(OrderRel.ReqDate))

Early: if (ShipHead.ShipDate - OrderRel.ReqDate) < 0 then 1 else 0

Does this help?

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
kirsty2179
Sent: Monday, April 20, 2009 8:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Data range formula

Looking to do calculated field within BAQs for data range It's not my
strong point

The Release date and the receipt date we want to add a column to say if
this is +1 or -1 ect

Any help would be great



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Looking to do calculated field within BAQs for data range It's not my strong point

The Release date and the receipt date we want to add a column to say if this is +1 or -1 ect

Any help would be great