Calculated items with aggregate measures

May15 — Tue, 11 Jul 2017 14:15:44 GMT

Hi all,

Is it possible to create a new item ins SAS Visual Analytics (Report designer) like this:

if (distinct(A)>1) return "abc"
else return A

A is a category and abc is a string.

Thanks,

Re: Calculated items with aggregate measures

abcde — Wed, 09 Aug 2017 22:05:32 GMT

Create a new aggregated measure ind use the boolean for the if statement and the aggregated to use distinct