12-06-2016 12:22 AM
My data looks like this
ID '28-Feb-14'n ...'28-Feb-16'n Policy_Start
101 90.20 ..... 30.89 21JAN2014
102 76.90 ....... 45.67 13MAR2015
103 66.66 ...... 67.45 20JUN2015
i need to add up all the columns which are less than this formula
New_Column=(sum(all_columns_which are less than policy_start+365 )<(policy_start+365))
please kindly note all the columns names are with date.
So how i refer only those columns to sum up .
Please revert asap.
12-06-2016 01:27 AM
Question: what about leap years? Do you really want policy_start+365, or do you want INTNX('year',policy_start,1,'s')? (look it up).
12-06-2016 02:15 AM
Transpose your data to a long format makes this much easier.
Dates shouldn't be variable names - you're storing information in your variable names.
This is fine for reporting but not great for data analysis.
It's harder to develop dynamic processes around variable names that constantly change and the number of variables will also change. And when adding data you have to add new columns instead of rows.
Can you change your data to a long format for analysis and then transpose for reporting?