Forum Discussion

nasolme's avatar
nasolme
Helper I
4 years ago
Solved

hide subtotal

Hi community !

I would like to keep only the grand total for "Loan" columns. 

I can use :

IF(HASONEVALUE(ASSET[ASSET_NUMBER]),blank(),sumx(SUMMARIZE(DATA,DATA[FILE_NUMBER],"average",average(DATA[ENCOURS.MT_EXPO_BRUT_Engagements])),[average]))

 

But logically, i get blank row  when i have only one asset number.


Somebody has an idea to correct my measure ?

 

 

 

Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    nasolme 
    IF(ISINSCOPE(ASSET[ASSET_NUMBER]),blank(),sumx(SUMMARIZE(DATA,DATA[FILE_NUMBER],"average",average(DATA[ENCOURS.MT_EXPO_BRUT_Engagements])),[average]))

2 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    nasolme 
    IF(ISINSCOPE(ASSET[ASSET_NUMBER]),blank(),sumx(SUMMARIZE(DATA,DATA[FILE_NUMBER],"average",average(DATA[ENCOURS.MT_EXPO_BRUT_Engagements])),[average]))