🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

"Macro to calulate % of a value"

User: "Anki"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with