Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
Pivot table # of fields | Excel Discussion (Misc queries) | |||
Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) |