Hi,     =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.     ... View more

  Hi,   I m trying to create a calculated fieldfor a report. I have to create an item with a range and I using If else boolean for this. Here, i have to get the output as numeric with combination of date and numeric. i m not able to create an item with date and range between numeric where as the ouput should be a nuemeric. Please suggest.. ... View more

Hi,   I working on SAS VA, do we code and decode in sas analytics ? I never came across with this before. To pull an attributr from another sas tool which is coded, can this be coded and decoded ? ... View more