![]() |
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 |
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 |
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 |
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