Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to calculate the value of an expression exclusively for a group of data and compare them with one value; in my case, the solvency ratio for one company and compare these ratio with different sector´s companies
I´m calculating the solvency ratio where:
Solvency ratio = $(vEquity)/$(vAssets) (as a master element)
vAssets = sum({<IDAccount={'10'}>}Money)
vEquity = sum({<IDAccount={'30'}>}Money)
The groups of companies are like these:
IDGeneral | Type | IDSystem | System | IDLicense | License | IDCompany | Company | NoCompany |
1111 | A | 1 | A | 1 | A | 1 | A | 1 |
1212 | A | 1 | A | 2 | B | 1 | A | 2 |
2121 | B | 2 | B | 1 | A | 2 | B | 1 |
2222 | B | 2 | B | 2 | B | 2 | B | 2 |
2223 | C | 2 | B | 2 | B | 2 | B | 3 |
I need to compare the Solvency ratio of my company (IDGeneral = 1111) against the groups whose IG general starts with '12', '21' and '22' in a bar graph
You may create one synthetic Dimension in bar chart as - Valuelist('MyCompany','Startswith12','Startswith21','Startswith22')
and measure as -
Pick(Match(Valuelist('MyCompany','Startswith12','Startswith21','Startswith22'),'MyCompany','Startswith12','Startswith21','Startswith22'),
Expressionforyourcompany,Expressionfor12,Expressionfor21,Expressionfor22)
The expessions in above measure can calculate specific values for other groups like -
vAssets12 = sum({<IDGeneral={"12*"}>}Money)
vEquity12 = sum({<IDGeneral={"12*"}>}Money)