Dear SAS Wiz, Need help fixing the error i am facing , that An Element must be aggregated and cannot be used here.... I am facing an issue while attempting to , plesae see screenshot of the same error :    i am trying to get the Variance and subtracing previous quarter to current quarter and be able to add the visuals like adding an Arrow up if the difference is more and down if the difference goes negative ... the quarter 1 is configured as below:       ... View more

Dear Team, I am currently working on a dashboard with a data source from a DataMart, i am trying to achieve adding a visual indicator for values with an arrow up and down which will have a rule to be applied. arrow up to be green once value goes up and down arrow with a color red once the values go down, so I could have a much nicer visual approach.    currently my calculations are all in aggragated measure and i could not add the "if else" as i am getting an error : Error message is :   ... View more