i have a report in the query desinger i am doing some variance calculation on two dates which are also key figure dates.
for ex: Adate and Bdate
its working fine when i have date in both the key figures but the problem is if one of the key figure doesn't have a value then its displaying -732687.
how can i restrict in the report so these values doesn't display
thanks and regards