"Macro to calulate % of a value"
Hi Matthias and all,
I want to write a macro to calulate 20% ( percent ) of a value. My problem is like this
CUST_ID TRAN_COUNT
--------------------------------------
23145 23
34562 87
I want to Iterate the process for each CUST_ID and In the inner loop I am reading data belongs to CUST_ID and I am passing it to "Outlier Analysis".
In Outlier Analysis I need to give input 'count_of_outlier' as 20% of TRAN_COUNT.
I am taking macro "extract macro" .....But How can I calulate % of that value?
Thank you
Yours
Anki
I want to write a macro to calulate 20% ( percent ) of a value. My problem is like this
CUST_ID TRAN_COUNT
--------------------------------------
23145 23
34562 87
I want to Iterate the process for each CUST_ID and In the inner loop I am reading data belongs to CUST_ID and I am passing it to "Outlier Analysis".
In Outlier Analysis I need to give input 'count_of_outlier' as 20% of TRAN_COUNT.
I am taking macro "extract macro" .....But How can I calulate % of that value?
Thank you
Yours
Anki