Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community,
I would like to count the data entries in straight tables that are generated by various expressions.
I am currently using two dimensions in the straight tables, company and account name.
Just counting the companies that show up in the table (9 in this case) would be enough, if I can count every single row (18) that's fine as well.
Thank you in advance!
I will attach the sample.
Best regards,
Mats
May be this
Count(DISTINCT Aggr(IF([FS Item] >= 100000 and [FS Item]<= 2000000 and Sum([Period Value GC]) < 0, [Company Name]), [Company Name], [Name Financial Statement Item]))
or this
Count(DISTINCT Aggr(IF([FS Item] >= 100000 and [FS Item]<= 2000000 and Sum([Period Value GC]) < 0, [Name Financial Statement Item]&[Company Name]), [Company Name], [Name Financial Statement Item]))
Can you try this, May be?
Count(Aggr(IF([FS Item] >= 100000 and [FS Item]<= 2000000 and Sum([Period Value GC]) <= 0, Sum ([Period Value GC])) ,[Name Financial Statement Item]))
For Total Rows
=sum(AGGR(if(sum({<[FS Item]={">=100000<=2000000"} >} [Period Value GC])<0,1),[Company Name],[Name Financial Statement Item]))
For Distinct count of Companies
=count(distinct AGGR(if(sum({<[FS Item]={">=100000<=2000000"} >} [Period Value GC])<0,[Company Name]),[Company Name],[Name Financial Statement Item]))
Check the attached
May be this
Count(DISTINCT Aggr(IF([FS Item] >= 100000 and [FS Item]<= 2000000 and Sum([Period Value GC]) < 0, [Company Name]), [Company Name], [Name Financial Statement Item]))
or this
Count(DISTINCT Aggr(IF([FS Item] >= 100000 and [FS Item]<= 2000000 and Sum([Period Value GC]) < 0, [Name Financial Statement Item]&[Company Name]), [Company Name], [Name Financial Statement Item]))
Works as well! Thanks.
Works like a charm, thanks!
works, thank you