05-19-2017 10:59 AM
=Sum((If <Trans Code (num)>=XX Then <Trans Number of Trans>) ForEach <Trans Code (num)>)
I m trying to convert a report from the mentioned BI Tool, I understnad the function partially. As I can do it individually with if function, but can we do aggrgated function with boolean as we do not find the option of aggregated fields while creating any calculated field. Please answer.
05-22-2017 01:05 PM
The request for data such as @kiranv_ is to show some actual values and what the result of that function would be.
Since this is SAS forum it is very possible that few of the users actually are familiar with SAP. I know that I know nothing about SAP.
But with example data sometimes I can work out a procedure that mimics displayed values.
Further complication is that Visual Analytics has a different set of data manipulation tools available than Base SAS or EG or Studio. So an example may be even more important for the subset of forum participants that know VA.