Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
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 :-
Money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
,
$(vMoneyFormatK))
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.
Paul Yeo
Hi,
You can refer to the link below.
Best regards,
Hi All
Enclosed my QVW
Paul
Hi,
You can refer to the link below.
Best regards,
Hi Sye
it work fine now. But i face one more issue below :-
Paul Yeo