Forum Discussion
undefined
Hi, I want to create the calculated column 'Individual sales Quantity' from the first three input columns. For the same date and same product ID, I want the Sum in only entry and another entry as 0 as shown above
Hi Rajni264
Why do you want to create a column like this?
What is the purpose of keeping a row with a 0 in it for Ind Sales Qty when it appears that what you are trying to do is sum the sales by product id and date?
Why not just use a table visual to do this?
regards
Phil
1 Reply
Hi Rajni264
Why do you want to create a column like this?
What is the purpose of keeping a row with a 0 in it for Ind Sales Qty when it appears that what you are trying to do is sum the sales by product id and date?
Why not just use a table visual to do this?
regards
Phil