Logic

[panipat1990]

Hi Team,

     I have a requirement...And I am Sharing A qvw........I have to Find. Frontend These Calucalation...

     1. Net Realisation=Net Revenue-Selling Cost

      2.Contribution=Net Realisation-Net Revenue-Selling Cost

     3.Total=Overhead+Overhead+Cost Unit+Exceptional

     4.Net Costag =Net Realisation/Total

How is it Possible..Please Help Me.....

[panipat1990]

Thanks Sir...it is really helpful for me...but our requirement we need to get these fields from backend...so what is the possible way find out....please help me on this..

[sunny_talwar]

Try this:

Inline:

LOAD * INLINE [

    Particulers, Budget, Actual

    Net Revenue, 1000, 1500

    Selling Cost, 2000, 2200

    Material Cost, 3000, 2500

    Variable Sale, 5000, 4000

    Overhead, 4000, 5000

    Systemitic Unit, 5000, 6000

    Cost Unit, 6000, 7000

    Exceptional, 7000, 6500

    Gain, 8000, 9000

    Less Cost, 9000, 10000

];

Temp:

LOAD 1 as ID,

  Budget as Rev_Budget,

  Actual as Rev_Actual

Resident Inline

Where Particulers = 'Net Revenue';

Join (Temp)

LOAD 1 as ID,

  Budget as Cost_Budget,

  Actual as Cost_Actual

Resident Inline

Where Particulers = 'Selling Cost';

Concatenate(Inline)

LOAD 'Net Realisation' as Particulers,

  Rev_Budget - Cost_Budget as Budget,

  Rev_Actual - Cost_Actual as Actual

Resident Temp;

DROP Table Temp;

Temp:

LOAD 1 as ID,

  Budget as Rev_Budget,

  Actual as Rev_Actual

Resident Inline

Where Particulers = 'Net Revenue';

Join (Temp)

LOAD 1 as ID,

  Budget as Cost_Budget,

  Actual as Cost_Actual

Resident Inline

Where Particulers = 'Selling Cost';

Join (Temp)

LOAD 1 as ID,

  Budget as Realization_Budget,

  Actual as Realization_Actual

Resident Inline

Where Particulers = 'Net Realisation';

Concatenate(Inline)

LOAD 'Contribution' as Particulers,

  Realization_Budget - Rev_Budget - Cost_Budget as Budget,

  Realization_Actual - Rev_Actual - Cost_Actual as Actual

Resident Temp;

DROP Table Temp;

Temp:

LOAD 1 as ID,

  Budget as OH_Budget,

  Actual as OH_Actual

Resident Inline

Where Particulers = 'Overhead';

Join (Temp)

LOAD 1 as ID,

  Budget as CU_Budget,

  Actual as CU_Actual

Resident Inline

Where Particulers = 'Cost Unit';

Join (Temp)

LOAD 1 as ID,

  Budget as Ex_Budget,

  Actual as Ex_Actual

Resident Inline

Where Particulers = 'Exceptional';

Concatenate(Inline)

LOAD 'Total' as Particulers,

  Ex_Budget + OH_Budget + CU_Budget as Budget,

  Ex_Actual + OH_Actual + CU_Actual as Actual

Resident Temp;

DROP Table Temp;

Temp:

LOAD 1 as ID,

  Budget as Realization_Budget,

  Actual as Realization_Actual

Resident Inline

Where Particulers = 'Net Realisation';

Join (Temp)

LOAD 1 as ID,

  Budget as Total_Budget,

  Actual as Total_Actual

Resident Inline

Where Particulers = 'Exceptional';

Concatenate(Inline)

LOAD 'Net Costag' as Particulers,

  Num(Realization_Budget/Total_Budget, '##.0%')  as Budget,

  Num(Realization_Actual/Total_Actual, '##.0%')  as Actual

Resident Temp;

DROP Table Temp, SortOrder;

[panipat1990]

Thanks sir....it is helpful for me...