Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

discounted p&l

Dear All

I prepared the VARIABLE PROFIT AND LOSS STATEMENT as shown in the attachment below, where the EXPENSES ACTUAL values ​​should be obtained and other values ​​should be adjusted according to the BUDGET RATIO. It has been prepared by me as below attachment. The problem I have is that when taking the value of NET PROFIT, it is not the value divided according to the BUDGET RATIO, but the GROSS PROFIT (this should be the gross frofit divided according to the budget ratio) should be subtracted from ACTUAL EXPENSES and added to it INVESTMENT INCOME. This should be done in the Discount_Budget field of my attachment. Can you please help me to calculate the NET PROFIT.

Thanking You



Labels (1)
0 Replies