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.....

[sunny_talwar · Accepted solution]

May be this:

[paul_vans267]

Hi there,

I moved your inline table into Excel and then used the Cross table wizard inside the File Wizard to change it into a flat table.

Then used the expressions that you suggested.

Hope this helps.

[panipat1990]

Hi Sir,

        I want to keep Net Realisation below Selling Cost......and Contribution  Below Material Cost Variable Sale......And Total Below Exception And Net Costag Below Less Cost...How is it possible

[sunny_talwar]

Add a sort expression:

=Match(Pick(SNo, Particulers, 'Net Realisation', 'Contribution', 'Total', 'Net Costag'), 'Net Revenue', 'Selling Cost',

'Net Realisation', 'Material Cost', 'Variable Sale', 'Contribution', 'Overhead', 'Systemitic Unit', 'Cost Unit', 'Exceptional', 'Total',

'Gain', 'Less Cost', 'Net Costag')

[sathishkumar_go]

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
];

Inline:
LOAD * INLINE [
Dimension
Net Realisation
Contribution
Total
Net Costag
];

-Sathish

[sathishkumar_go]

[sathishkumar_go]

Expression:

=IF(Dimension = 'Net Realisation', Sum({<Particulers = {'Net Revenue'}>} Budget) - Sum({<Particulers = {'Selling Cost'}>} Budget),
IF(Dimension = 'Contribution', (Sum({<Particulers = {'Net Revenue'}>} Budget) - Sum({<Particulers = {'Selling Cost'}>} Budget)) - Sum({<Particulers = {'Net Revenue'}>} Budget) - Sum({<Particulers = {'Selling Cost'}>} Budget),
IF(Dimension = 'Total', (Sum({<Particulers = {'Overhead'}>} Budget) + Sum({<Particulers = {'Overhead'}>} Budget)) + Sum({<Particulers = {'Cost Unit'}>} Budget) + Sum({<Particulers = {'Exceptional'}>} Budget),
(Sum({<Particulers = {'Net Revenue'}>} Budget) - Sum({<Particulers = {'Selling Cost'}>} Budget)) / ((Sum({<Particulers = {'Overhead'}>} Budget) + Sum({<Particulers = {'Overhead'}>} Budget)) + Sum({<Particulers = {'Cost Unit'}>} Budget) + Sum({<Particulers = {'Exceptional'}>} Budget))
)))

[sathishkumar_go]

Actual:

=IF(Dimension = 'Net Realisation', Sum({<Particulers = {'Net Revenue'}>} Actual) - Sum({<Particulers = {'Selling Cost'}>} Actual),
IF(Dimension = 'Contribution', (Sum({<Particulers = {'Net Revenue'}>} Actual) - Sum({<Particulers = {'Selling Cost'}>} Actual)) - Sum({<Particulers = {'Net Revenue'}>} Actual) - Sum({<Particulers = {'Selling Cost'}>} Actual),
IF(Dimension = 'Total', (Sum({<Particulers = {'Overhead'}>} Actual) + Sum({<Particulers = {'Overhead'}>} Actual)) + Sum({<Particulers = {'Cost Unit'}>} Actual) + Sum({<Particulers = {'Exceptional'}>} Actual),
(Sum({<Particulers = {'Net Revenue'}>} Actual) - Sum({<Particulers = {'Selling Cost'}>} Actual)) / ((Sum({<Particulers = {'Overhead'}>} Actual) + Sum({<Particulers = {'Overhead'}>} Actual)) + Sum({<Particulers = {'Cost Unit'}>} Actual) + Sum({<Particulers = {'Exceptional'}>} Actual))
)))

[sathishkumar_go]

-Sathish