Analytics Software

Hello,

I am having some problems in a “pivot table”, “Sections” and “Calculated Items” I have a section called 'e) External Income' and I would like the value reverted from a negative to a positive. In excel or any other form of calculation you can do this by * -1 (negative 1). However this statement does not work as a Calculated Item. This is the statement I am using = 'e) External Income'*-1 and I get the following error message “The semantics of the formula entered are not valid”.

I have also tried = 'e) External Income'-('e) External Income'+'e) External Income') this will give you it as a minus also but I have no error message this time, but the values stay the same.

Can this be done any help would be very appreciative.

Thank you

John