topic SAS VA on SAS Viya for Learners Question in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-on-SAS-Viya-for-Learners-Question/m-p/801161#M15878 <P>Hello!</P> <P>&nbsp;</P> <P>I have the list data object that appears in image 1.</P> <P>&nbsp;</P> <P>The distinct orders is a calculated measure that has been derived by the formula in image 2.</P> <P>&nbsp;</P> <P>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?</P> <P>&nbsp;</P> <P>BR,</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Andreas<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="VA.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/69301iE0C1596C3722FAD3/image-size/large?v=v2&amp;px=999" role="button" title="VA.png" alt="VA.png" /></span></P> Wed, 09 Mar 2022 18:46:37 GMT andreas_zaras 2022-03-09T18:46:37Z SAS VA on SAS Viya for Learners Question https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-on-SAS-Viya-for-Learners-Question/m-p/801161#M15878 <P>Hello!</P> <P>&nbsp;</P> <P>I have the list data object that appears in image 1.</P> <P>&nbsp;</P> <P>The distinct orders is a calculated measure that has been derived by the formula in image 2.</P> <P>&nbsp;</P> <P>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?</P> <P>&nbsp;</P> <P>BR,</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Andreas<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="VA.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/69301iE0C1596C3722FAD3/image-size/large?v=v2&amp;px=999" role="button" title="VA.png" alt="VA.png" /></span></P> Wed, 09 Mar 2022 18:46:37 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-on-SAS-Viya-for-Learners-Question/m-p/801161#M15878 andreas_zaras 2022-03-09T18:46:37Z Re: SAS VA on SAS Viya for Learners Question https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-on-SAS-Viya-for-Learners-Question/m-p/801174#M15879 I found it,<BR /><BR />I had to use in the numerator the following calculated filed.<BR /><BR />Sum _byGroup_ (Net_Sales)<BR />Thanks<BR /><BR /><BR /><BR /> Wed, 09 Mar 2022 19:40:02 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VA-on-SAS-Viya-for-Learners-Question/m-p/801174#M15879 andreas_zaras 2022-03-09T19:40:02Z