Total Sales Calculation Problem

[Anonymous]

Hi Everyone,

     I have created a straight Table for sales calculation with respect to billing days. I have loaded the Billing and Sales values per year and country wise and I have used the division formula (i.e [Sales to date}/[Billing Days to Date]) to perform the calculation to show the final sales in the respective years. The problem now is, the formula works fine for individual sales vs billing days and gives the correct output. But when it comes to the totals the division operation is not performing well. Can anyone please tell me where I might be doing the mistake. I am attaching the screenshot for reference.

Thanks in advance.

[Gysbert_Wassenaar]

Check the syntax of the expression. Make sure to use the exact case sensitive field names.

[Anonymous]

Hi Pratik,

    It is working fine even in total mode when I set all the three expressions to "Expression Total" in total mode which is not the requirement.

[Anonymous]

I did Check the syntax multiple times and I even tried putting the entire expression in a variable and using it instead of field names. Nothing Worked!!

[Gysbert_Wassenaar]

Then either give up or post a qlikview document that demonstrates the problem so somebody else can have a look at it. As you've noticed letting us guess is wasting time for all of us.

[PrashantSangle]

Hi,

Try,

Column(2) / Column(1)

Considering Column(2) as ([Sales to date])

and Column(1) as [Billing Days to Date]

As Gysbert suggest post your app.

[Anonymous]

I'll try and create a sample document and post it.

[PrashantSangle]

Hi,

Try my suggestion.

Since you can not use Sum() on columnName therefore it is giving you error.

Regards

[Anonymous]

Hi

PFA Sample Data and QVW

[Anonymous]

Hi Andrew,

PFA Sample QVW and Data.

[Gysbert_Wassenaar]

Where's that final sales expression you mentioned in your opening post? I don't see that in the document you posted.