hi guys I am using the following script to create a table as below:
tmp:
LOAD
%LeaseKey,
max([Expense Amount]) as MaxExpense
RESIDENT Expense
GROUP BY %LeaseKey;
LEFT JOIN (tmp) LOAD
%LeaseKey,
[Expense Frequency]
RESIDENT Expense;
Result:
LOAD
%LeaseKey,
MaxExpense,
MaxExpense * 12 as [Annuallized Cost]
RESIDENT tmp;
DROP TABLES Expense, tmp;
the result looks like the below when loaded into a table box. and it is correct
%LeaseKey Max(Expense Amount) Annual Amount
1 1000 12000
2 625 7500
3 400 4800
When I try to build the same table into a table chart I get wrong nrs(away higher than what's above.)
I am assuming that I should get the same nrs as the table above.
Any suggestions on what's wrong!
Thxs,
