Format the Measure for Negative Weighted Alternate hierarchy ?

[donap]

Hi all.
I have the following Scenario of a dimension with an alternate with a negative weighted subsequent "c" level -
The "Alpha Accounts"  total is correctly subtracted from "Num Accounts" to get the correct value for "Num vs Alpha Accounts"
The issue is -- the users want to see  the "Alpha Accounts"  total  as a Negative number..They don't necessarily know exactly which is a neg weight or not, and in Excel-Cafe , if they want to add a calculation,  they want to make sure if they "add" the value reflects negatively.
Is there a way to do this  ?
Thanks



All Accounts   6,348,162,498    
            123         1,235,097    
            456   2,347,980,184    
            789        88,928,401    
             abc    3,819,123,804    
             def        90,895,012    
            
Num vs Alpha Accounts   (1,471,875,134)    (alternate )
    Num Accounts             2,438,143,682     (alternate )
                   123                   1,235,097    
                   456            2,347,980,184    
                   789                  88,928,401    
     Alpha Accounts             3,910,018,816    (alternate - Neg Weight) *****
                    abc              3,819,123,804    
                    def                  90,895,012    

[AJAYC]

Hi Donap

Apologies in advance if I have not quite understood your post, but does the below work for you:

All Accounts   6,348,162,498
       123              1,235,097 ( 1)
       456        2,347,980,184 ( 1)
       789             88,928,401 ( 1)
       abc         3,819,123,804 ( 1)
       def              90,895,012 ( 1)



Num vs Alpha Accounts    (1,471,875,134)
Num Accounts                 2,438,143,682  ( 1)
Alpha Accounts              (3,910,018,816) ( 1)


Num Accounts             2,438,143,682
       123                            1,235,097 ( 1)
       456                     2,347,980,184 ( 1)
       789                          88,928,401 ( 1)

Alpha Accounts          (3,910,018,816)
       abc                      3,819,123,804 (-1)
       def                           90,895,012 (-1)


HTH
Ajay

[donap]

Thanks I will try that and see what feedback I get from the users !