SAS VA on SAS Viya for Learners Question

[andreas_zaras]

Hello!

I have the list data object that appears in image 1.

The distinct orders is a calculated measure that has been derived by the formula in image 2.

I want to get the Net Sales per order so i try to use the formula in image 3. I get errors. How can i do this task?

BR,

Andreas

[andreas_zaras · Accepted solution]

I found it,

I had to use in the numerator the following calculated filed.

Sum _byGroup_ (Net_Sales)
Thanks