42953_en-US

liliconcom

Name Unresolved Error after column doing summary table

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)")<dtsplit<

 

Thanks

Re: Name Unresolved Error after column doing summary table@EqienAK : Please paste sample data table else it is not possible to reproduce or understand the issue .

Best
udayRe: Name Unresolved Error after column doing summary table

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

 

Re: Name Unresolved Error after column doing summary table

@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<

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<