Need help in writing expression

[#1]

Hello Guru's.

I am trying to create weekly report, when you see the below detail

Week,

# of overdue invoices(Count of overdue Invoices)

Sum overdue invoices (Sum of overdue invoices)

# of Invoices (Count of Invoices)

Sum of Invoices(Sum of Invoices)

as I am facing problem in Pivot table, if there is no data for a week, it has to display 0 for instance Week 6 has no data I need to dispaly week 6 has 0 in all columns.

In the database itself the week value is not written in the table, I tried like if Week is null or 0 the number and sum of invoice is 0 but its not working,

can anyone share their ideas.

secondly based on this value I trying to create a line chart if there is no data the lines should touch the 0 and then travel but its not working for me

WEEK	#Of Over Due Invoices	Sum of Over Due Invoices	# Of Invoices	Sum Of Invoices
1	10	9 257,19	10	9 257,19
2	9	4 807,19	9	4 807,19
3	11	8 862,58	11	8 862,58
4	10	5 896,55	10	5 896,55
5	9	4 807,19	9	4 807,19
7	2	8 621,99	4	14 501,99

Regards

Chriss

[CELAMBARASAN]

Hi,

     You should have data in a table to display in the dimensions.

     So use below for week

WeekTable:

LOAD

          RecNo() AS Week

AutoGenerate 52;

Then use all your expressions like below

     =Alt(Expression,0)

Don't forget to uncheck the suppress zero values in the presentation tab.

Celambarasan

[#3]

Dear Celambarasan,

Thanks for your reply, as I have tried what you suggested, I have forgot to tell you one thing, actually I have checked the database the data which is not available for week 6 is for only one customer and rest of the customers had the values.

When I select this particular customer, the 6th week value is not there as I have given in the table its showing and more than I have tried using Load statement and the Alt() expressions, its not working.

Can you suggest me is that any other solution to do this..

Regards

Chriss

[CELAMBARASAN]

Hi,

    Have you Checked the Show all values in the Dimension tab?

Celambarasan

[#5]

Dear Celambarasan,

Exactlly works but at the end "-" is coming, I need to avoid this hypen.

can you help me on this...

Regards

Chriss

[CELAMBARASAN · Accepted solution]

Hi,

     This displays due to Null value in the week field to hide that in the same Dimension tab check the Suppress when value is null option which is above the show all values.

Celambarasan

[#7]

Dear Celambarasan,

Thanks a lot, its works............

Regards

Chriss