Hello, I have in SAS VA an aggregated measure as follows:   IF ( ( Sum [_ByGroup_] ('Lf. Monat'n) <> 0 ) AND ( Sum [_ByGroup_] ('UMS'n) <> 0 ) ) RETURN ( Sum [_ByGroup_] ('Lf. Monat'n) / Sum [_ByGroup_] ('UMS'n) ) ELSE 0   This formula calculates now on all members of a category called POSITION. I want to limit now the calculation on all positions except the one calle "FAKT_STD". So it should look similar to this one:    IF ( ( Sum [_ByGroup_] ('Lf. Monat'n) <> 0 ) AND ( Sum [_ByGroup_] ('UMS'n) <> 0 ) AND ( POSITION<> 'FAKT_STD' ) ) RETURN ( Sum [_ByGroup_] ('Lf. Monat'n) / Sum [_ByGroup_] ('UMS'n) ) ELSE 0 Unfortunately this expression is not accepted by the system. Does anybody know how the expression should look like? Thx Robert ... View more

Hi All,   This is my first posting on this community. We are using currently SAS VA 7.3 (in collaboration with SAS Financial Management 5.5) and our users would like to have a tabular Report like this:     The column flag indicates the delta in % between the columns "Ist" and "Plan". I have not been able to find a way so far how to do this.   Best regards   Robert  ... View more