GL_TABLE: LOAD 'PMC' as SOURCE, [Account Code] as AccountCode, If([Account Code]>=5000000 and [Account Code]<=5999999,'P_Revenue') as [P_Revenue], If([Account Code]>=8000000 and [Account Code]<=8999999,'P_Exp') as [P_Exp], Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/MM/YYYY') as [date], [Deb./Cred. (LC)] AS Amount, [Account Name] AS GL_DESC_ FROM [C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\RAW DATA SAP\GL_PMC_2019.xlsx] (ooxml, embedded labels, table is [Modified GL Data]);
For Each i in 108 WhatIfDimension$(i): LOAD * INLINE [ Pls $(i)st Dim,Column$(i) YrMth,YearMonth DETAIL,GL_DESC_ SOURCE,SOURCE ]; NEXT i;
For Each i in 901,902 WhatIfDimension$(i): LOAD * INLINE [ Pls select $(i)st Dim,Column$(i) 01 Revenue,P_Revenue 02 Exp,P_Exp ]; NEXT i;
I use the below expression for list the total amount for Revenue or Exp depend on user selection :-
My Question is how to make both display positive value ? Since i plan to display the sales amount trend chart on positive value and Expense trend chart in positive value. As now Revenue display negative value , and Exp display positive value.