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
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
Thanks I will try that and see what feedback I get from the users !