Date:         Fri, 19 May 1995 19:40:32 +0000
Reply-To:     The NOMAD2 Discussion List
Sender:       The NOMAD2 Discussion List
From:         Stace Cameron
Subject:      Re: ZNAV

> My question regards using ZNAV in LIST.  Here's my database:
>
>           Item1 as A20
>           Item2 as 999.99
>
>
> My goal:  a summary report by item1.  Some of Item2's values are
> &nav.

Doesn't list by item1 sum(item2) give you what you want?
>
>
> I conclude that you can't combine ZNAV with SUM.  But what I find
> more curious is that the expression ZNAV(ITEM2) while allowed in
> the DEFINE, is not allowed by LIST, even without any SUM function
> in front of it; ie:
>
>         LIST FROM MYDB BY ITEM1
>                        ZNAV(ITEM2)
>
Try LIST by ITEM1 ((znav(ITEM2)).  Remember that expressions must be
surrounded by (...)

Stace Cameron
Southern Illinois University - School of Medicine
scameron@siumed.edu
back to index