Category help!

[amit_saini]

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

[micheledenardi]

Can you share the file PST_Version 118_23.04.2018.xlsm ?

[micheledenardi]

Because all value of "Total Cost" category are already included in previous if(match()) conditions...

[amit_saini]

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