turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Name Unresolved Error after column doing summary t...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 8, 2017 1:45 AM
(472 views)

hi guys,

Appreciate some help here.

i was trying to create another column and add formula to substract the value of column Sum(:E09) to N Rows when error below came out:

Column DFF_CSE09% Formula Interrupted

Name Unresolved: Sum(E09) 1 times At rows: {1} Operation: Sum(E09), :Name( "Sum(E09)" )

Formula evaluation errors have been ignored

I use below code:

dt<< Summary(

Group( :NAME, :PROGRAM ),

Sum( :E09 ),

Sum( :E10 ),

Sum( :E11 ),

Sum( :E12 ),

Sum( :E15 ),

Sum( :Net_E )

);

:Name("Sum(D09)")<<Set Name("09_a");

dtsplit<<New Column("E09_Percentage",Numeric,Continuous,Formula(:9_a - :N Rows));

Thanks

3 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 8, 2017 9:26 AM
(456 views)

@EqienAK :

May I request that you post the data table or a sample of the data table you are working with for users to be able to reproduce the issue on their end ?

Before looking at it - my first take is you have the column name called out incorrectly . I would think the following needs to be edited to

dtsplit<<New Column("E09_Percentage",Numeric,Continuous,Formula(:9_a - :N Rows));

N Rows is an inbuilt function and I would advice you against using it as a column name.

If it is not a column name - it requires an argument to be processed .

dtsplit<<New Column("E09_Percentage",Numeric,Continuous,Formula(:Name("09_a") - N Rows(dt));

Best

Uday

Uday

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 9, 2017 7:35 PM
(421 views)

hi @uday_guntupalli;

basically i already did a summation of table and i was trying add new column to get the percentage of (E09-N rows).

product N rows E09

AB 3 2

AC 5 3

CA 7 4

WW 8 4

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 10, 2017 8:46 AM
(401 views)

Best

uday

Best

Uday

Uday