Max Date Values not showing in Report

[#1]

Dear All,

            In my report i used following condition, its not working without selection

     = sum(if(Date=MaxDate,remainingOutgoing))

For Eg.

if i select customer No. C000003 then it showing the Value, if i press clear button then its not showing on the report.

Can any one help me!

Regards,

Antony.

[kaushiknsolanki]

Hi,

     if you are using this in listbox ot textboxm it will not work because Date is a field and contains many values.

     What you can do is create a Straight table-> give dimention as Date and use the above expression in expression.

     This will work. or else upload the qvw.

Regards,

Kaushik Solanki

[#3]

I used the Expreesion in Straight Table but its not working....

[#4]

Hi,

Please find attached Application...

Regards,

Antony.

[#5]

Please check the feild "Remaining"

[kaushiknsolanki]

Hi,

    It will not work, as i said earlier Date is not a single value. When you give dimension as Date the expression takes Each date. The reason is each row of a date dimnension is a single date and which can be compared with your maxdate.

   Think about your expression it. sum(if Date= MaxDate,........) what date you expect to be comapred with MaxDate.

   I hope you understood the problem

Regards,

Kaushik Solanki

[kaushiknsolanki]

Hi,

    You can use set analysis like Sum({$<Date = {$(#MaxDate)}>}remainingOutgoing)

    This will give you the sun only if you have customer with remainingOutgoing on your MaxDate.

    I hope this will help you

Regards,

Kaushik Solanki

[#8]

i did not understand above issue....

how do i solve this problem any idea???

Regards,

Napolean.

[#9]

Hi,

     i tried below set analysis, its not working

Sum({$<Date = {$(#MaxDate)}>}remainingOutgoing)

[kaushiknsolanki]

Hi,

    Can you tell me what data you want in Total.

Regards,

Kaushik Solanki