Values not showing in straight table

[#1]

Hi

I have a straight table depicting an income statement with columns for preceding months, current month and YTD. I have a problem with one of the entries 'Other income'. There are values for 'Sep' and 'Oct' which only shows up when either 'Sep' or 'Oct' is selected in the list box with months. However when 'Nov'

is selected, the values disappear.

I can't see any problem with my expressions. I'm attaching the Qvw file and will appreciate if someone can have a look please. Don't know what I'm doing wrong here.

Regards

Danie

[Anonymous]

I don't have the solution but I think I can tell you the reason why the values dissapear.

I think it its because November does not have any values for "Other Income"

So when you select November QV thinks it has nothing worth showing.

I will try to figure out your formula but it looks pretty complex ... 🙂

[#3]

Hi Dennis

Thank you for replying. What I don't understand though is that 'Stock depreciation' also doesn't have values in all the months but shows 0 when there is nothing for that month.

Regards

Danie

[#4]

Hi Dennis

Thank you for replying. What I don't understand though is that 'Stock depreciation' also doesn't have values in all the months but shows 0 when there is nothing for that month.

Regards

Danie

[Anonymous]

It think has something to do with the varaibles you use.

When you select November you dont have a date field for  : IF([PL_Line Description]='Other Income',

So also no vMaxDate or vMaxMonth because they are based on your date field.

Hope this is helpfull for you.

Good Luck,

Dennis.

[Anonymous]

'Stock depreciation' does have values and it does have a date attached to it for november.

Just make a table box with the fields Date (or Month) and PL_Line Description and you will see.

[#7]

Hi Dennis

I see what you mean. In a way QV still handles it correctly because although the values disappear when 'Nov' is selected, the subtotals and totals are still correct. So it's more of a display problem than anything else. A workaround is to select all the months you want to display in the straight table instead of just Nov.

Thank you for helping.

Regards

Danie

[#8]

Hi Dennis

I see what you mean. In a way QV still handles it correctly because although the values disappear when 'Nov' is selected, the subtotals and totals are still correct. So it's more of a display problem than anything else. A workaround is to select all the months you want to display in the straight table instead of just Nov.

Thank you for helping.

Regards

Danie