Hi Sam,   Sorry for the confusion. Yes, it is the same problem.   I was just trying to simplify the problem by using a generic header (Calculated Item 1,2,3) instead of bogging anyone down with the actual variables (i.e. OrderTotal). I had to start quoting the actual variable name when we started to talk in detail.   You bought up a very good point about missing data or some incorrect data messing up the calculations. However, if it is a missing data issue, would you say that it will affect the aggregated measure as well?   I am just a beginner using SAS Viya and I am very thankful for your help and inputs. 🙂 I will take a look at the example but I am not very confident of doing coding in SAS (or anywhere) though.                 ... View more

Hi Sam,   Apologize for the slow response. Due to the time zone difference, it might take me a while to get back to you.   Total Expense is a calculated item. I tried calculating it in 2 ways,   1st method Adding up the four individual cost together. Then using OrderTotal less Total Expenses.     2nd Method Using OrderTotal less the 4 individual cost in 1 step.   Final Step I then use the net profit calculated from both methods to divide against the OrderTotal. No matter which method was used, the net profit amount will be correct but the net profit percentage will be wrong.   You were asking about how detailed is my dataset. I have provided a sample screenshot if it helps.   Does it help if I provide the source file? The dataset is very big (total 650mb) but I can extract 10% of it (65mb) for you to test if it helps?   Thank you.   Regards, KS         ... View more

Hi Sam, Thank you so much for your help. I tried recreating using your suggestion and it worked! However the measures are now being classified as Aggregated Measure and cannot be use to carry out other analytics such as linear regression and forecasting. Do you have any other suggestions on how I might be able to work around it?   The problem I encountered arises when I had to calculate the net profit( which is the calculated item 3) by using OrderTotal less Total Expenses which is made up of 4 cost items (Product, Marketing, Distribution & Sales). I was able to calculate gross profit without using any aggregate measures; the only difference is that Gross Profit is calculated using OrderTotal Less Product Cost. Do you have any idea why I was able to calculate gross profit and not net profit?     Regards, KS       ... View more