1 Reply Latest reply: Nov 7, 2018 12:48 PM by Sunny Talwar RSS

    How to return negative numbers from sum of positive numbers

    Claudia Lettten

      Here us my expression . It is calculated as positive but I need to show them as negative in a bar chart. The money format is not working

       

      Sum({$<ScenarioVersionID = {$(CurrentScenarioID)}, Source = {'Earnings'}>} if(wildmatch(Line,'5a','5b','5c'), Amount))

       

      Here is my number format :

       

      Money    $#,##0;($#,##0)