Forum Discussion

WestWinter's avatar
WestWinter
Icon for Helper II rankHelper II
5 years ago
Solved

HASONEVALUE alternatives?

So I currently have this formula that works well to show a blank value at an aggregate level, while showing up correctly at a row level. However, I noticed that if the aggregate level only has one va...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi WestWinter 

    you can try like this,

    turn off Row subtotals

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

WestWinter , Not clear with your example. 

 

Can you share the expected output and data source (some sample data). 

Seem like you need to check if the below level has only one row. In that can we need create a formula with allexcept  

WestWinter's avatar
WestWinter
Icon for Helper II rankHelper II
5 years ago

amitchandak This is an example of I have on my matrix by using HASONEVALUE formula above if there is only 1 row of value for a particular section (in this case, USA for North America/America).

 

Require the rows (Americas and North America) to be blank like what is happening for Asia & North Asia.

 

Thanks!

 

CountriesCountry Code
AmericasUSA
   North AmericaUSA
       United States of AmericaUSA
Asia 
   North Asia 
       ChinaCN
       JapanJP
       KoreaKR