Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
how can I use many filters to get a sum() ?
My script:
load ID, Name, City, Amount From ...
Now I want to use a statusbox, to sum the amount with specific filter like: amount from Berlin and London; or amount from Dublin,...
with that funktion filter, I want to show the amount, that I really need.
Because I want to show many Amounts without selecting by clicking this to compare them - like to have an overview in my statisticbox with many sums..
Load SUM(Amount) as TOTALAMT Resident Temp
Where ID >=3 and ID <=5 Group By ID;
CONNECT TO DB1;
Database:
Load "Posting Date",
Month("Posting Date") AS Month,
Year("Posting Date") AS Year,
Amount,
Description,
"Document No_",
"Entry No_",
"G_L Account No_",
"Global Dimension 1 Code",
"Global Dimension 2 Code",
SUM(Amount) as AmountGlobal where "Global Dimension 1 Code" = 'T83400' or "Global Dimension 1 Code" = 'T83500' or "G_L Account No_" <=479999 and "G_L Account No_" >=400000
;
SQL SELECT *
FROM "OBDC";
Now: I want a sum() of that expression ..
where I have to set the expression ?
1. in the load or
2. after the SQL; as a new table?
T1:
load "Global Dimension 1 Code", "G_L Account No_", SUM(Amount) as AmountGlobal Resident Database where "Global Dimension 1 Code" = 'T83400' or "Global Dimension 1 Code" = 'T83500' or "G_L Account No_" <=479999 and "G_L Account No_" >=400000 Group By "Global Dimension 1 Code";
In the load side...