Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I'm using below simple logic:
fact:
LOAD
[GuV Zeile] as Income_Statement,
if(Match([GuV Zeile],'I - Raw material','J - Other components','K - Freight-in','L - Int. delivered mat. [Germany]','M - Discounts'),'Production Material',
if(Match([GuV Zeile],'N - Direct labor'),'Direct Labour',
if(Match([GuV Zeile],'P - Contract labor'),'Contract Labor',
if(Match([GuV Zeile],'R - Indirect personnel','S - Temporary Ind. Employees','T - Other overhead'),'Overhead/Temp Emp',
if(Match([GuV Zeile],'X - thereof all other','Y - HQ allocation [Germ. & KNA]','Z - Plant to plant charging'),'Other Operating Inc/Exp',
if(Match([GuV Zeile],'F - Freight-out','G - Packaging','H - Commissions'),'Distribution',
if(Match([GuV Zeile],'Q - Energy'),'Energy',
if(Match([GuV Zeile],'U - Maintenance (material & outside)','V - Repair moulds/fin. Lines','W - Depreciation'),'Other Fixed Costs',
if(Match([GuV Zeile],'F - Freight-out',
'G - Packaging',
'I - Raw material',
'J - Other components',
'K - Freight-in',
'L - Int. delivered mat. [Germany]',
'M - Discounts',
'N - Direct labor',
'P - Contract labor',
'S - Temporary Ind. Employees',
'T - Other overhead',
'U - Maintenance (material & outside)',
'X - thereof all other',
'Z - Plant to plant charging'),'Total Cost'))))))))) as Cost_Type
FROM
....................
But no sure why "Total Cost" has not been displayed inside Cost_Type:
Thanks,
AS
Can you share the file PST_Version 118_23.04.2018.xlsm ?
Because all value of "Total Cost" category are already included in previous if(match()) conditions...
Yes I know that , but looking for a way to categorize them on script side, not sure if this is possible.
As they are associated with Cost , so for time being I'm calling them different expressions as combination of Cost and Income Statement.
Regards,
AS