ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Totaling Fields (https://www.excelbanter.com/excel-discussion-misc-queries/116792-totaling-fields.html)

Ananth

Totaling Fields
 
I am updating the field YTD-2006 with month fields which are 5 decimal.
I am using nz([Table]!Jan,0)+ nz([Table]!Feb,0)€¦.. nz([Table]!Dec,0) etc..
However, I am not seeing the decimal results in YTd-2006 Field. Can anyone
enlighten me, where the mistake lies.

Thanks in advance


Fred Smith

Totaling Fields
 
What does the function "nz" do?

If it's your equivalent of the Round function, that's your problem. You are
rounding your results to zero decimal places. Simply take it out.

--
Regards,
Fred


"Ananth" wrote in message
...
I am updating the field YTD-2006 with month fields which are 5 decimal.
I am using nz([Table]!Jan,0)+ nz([Table]!Feb,0)... nz([Table]!Dec,0) etc..
However, I am not seeing the decimal results in YTd-2006 Field. Can anyone
enlighten me, where the mistake lies.

Thanks in advance




Dave Peterson

Totaling Fields
 
You may want to copy directly from the formula bar and paste into your message,
too.

Ananth wrote:

I am updating the field YTD-2006 with month fields which are 5 decimal.
I am using nz([Table]!Jan,0)+ nz([Table]!Feb,0)€¦.. nz([Table]!Dec,0) etc..
However, I am not seeing the decimal results in YTd-2006 Field. Can anyone
enlighten me, where the mistake lies.

Thanks in advance


--

Dave Peterson

Ananth

Totaling Fields
 
Nz function is applied to return zero, a zero-length string (" "), or
another specified value when a Variant is Null.It has nothing to do with
round function.

"Fred Smith" wrote:

What does the function "nz" do?

If it's your equivalent of the Round function, that's your problem. You are
rounding your results to zero decimal places. Simply take it out.

--
Regards,
Fred


"Ananth" wrote in message
...
I am updating the field YTD-2006 with month fields which are 5 decimal.
I am using nz([Table]!Jan,0)+ nz([Table]!Feb,0)... nz([Table]!Dec,0) etc..
However, I am not seeing the decimal results in YTd-2006 Field. Can anyone
enlighten me, where the mistake lies.

Thanks in advance






All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com