Hi @Stu_SAS, Thanks for your time assisting on this.
I have the below data structure:
1 – status , directly from SAS table
2 – count , directly from SAS table
3 – % calculated data item – aggregate measure created as below
Sum [_ByGroup_] ('count'n) / Sum [_ForAll_] ('count'n)
Format Percentage applied
4 – % calculated data item as above, but with out percentage format
In your example, both the fields already in sas table. I tried to replicate the example on on sas sample cars table and it worked. In my case (table structure above), I have to use % field (calculated data item – Aggregated measure) in conjunction with status. Is it possible to use one field that is part of the sas table (…status) and another an aggregate measure (%) together in an expression to my requirement to colour bar chart – bar (overdue) and % >0.003.
I tried below expressions using calculated item Aggregate measure %–
IF ( Sum [_ByGroup_] ((
IF ( UpCase('Status'n) = 'OVERDUE' )
RETURN '%'n
ELSE . )) > 0.001 )
RETURN 1
ELSE 0
(IF ('STATUS'n ='Overdue') return ((sum [_ByGroup_] ('%_num'n)) ELSE .) >0.002 )
return 1
else .
Thanks,
RP
... View more