user04775

Discussions

CAlculated Average to include in my datasource
Hi All, I need help since I am not familiar with sql, but I need to a column with the calculated average for a particular product which does not have averages available in my datasource. This is a small sample of my data: As you can see the AUM product does not have an average balance in the source system hence it has to…
Create a tier label based on the aggregate value of the client instead of the account level
Hi. Wondering if somebody can help me with the creation of Tier Labels based on the aggregate values at client level and not the individual account. My data is organized as follows Reporting month Account Product Type ClientNo. Balance This is what I was doing but I got stuck with the creation of the labels and the…