No, I am not summarising any table I just want to see the invoice value per month but also want to see the individual invoices and sales order these invoices belongs to, thats why I piicked up the invoice detail table, I can show individual values of ExtPrice, discount, Total Misc Charge, AdvanceBill Credt and Tax Amount, but now I want add them all to get the total value per invoice detail but where there is no tax, it is giving me an error, so I was trying to convert the tax amount in a calculated field to say that if tax is null then 0 else tax amount. but it doesnt work due to the null value.
Second thing is I dont want to convert it into crystal as the beauty of dashboard is that you can go to the actual record by just right clicking the relevant number which obviously you cant do on crystal report.
any other suggestion would be much appriciated. thanks
Second thing is I dont want to convert it into crystal as the beauty of dashboard is that you can go to the actual record by just right clicking the relevant number which obviously you cant do on crystal report.
any other suggestion would be much appriciated. thanks
--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Ahh, true. Sorry. I'm only on my first cup of coffee.
>
> Are you summarizing the table to get your value?
>
> Are you dumping this to Crystal Reports? If so, it is more easily
> do-able in Crystal Reports......
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of emailrashidforum
> Sent: Monday, July 27, 2009 9:17 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ Null Value
>
> This thing works for character field but for the number (UD Fields) it
> doesnt work as number fields are always have a 0.00 value so they are
> not null. any other suggestion please. thanks
>
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> >
> > Compare the BAQ field to another field you always know will be NULL,
> for
> > example Number20 (UD field).
> >
> > Then you can use an If/Then statement in a Calculated field.
> >
> > Something like this:
> >
> > If YourTable.YourColumn = YourTable.Number20 then 0 else
> > YourTable.YourColumn
> >
> >
> >
> >
> > Vic
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of emailrashidforum
> > Sent: Monday, July 27, 2009 7:55 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] BAQ Null Value
> >
> > Is there a way to convert the null value to zero in a BAQ. I am trying
> > to calculate the total amount in invoice Detail, it works if there is
> a
> > tax against this invoice detail but it there is no tax against this
> > invoice detail then it doesnt calculate. any suggestions? Thnanks
> >
> >
> >
> > ------------------------------------
> >
> > 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
> >
>
>
>
>
> ------------------------------------
>
> 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
>