cancel
Showing results for 
Search instead for 
Did you mean: 

Problem faced in condition definition in Query output

Former Member
0 Kudos

Hi Gurus,

I have a scenario where i have flat file input with Regcode, Weekno, Vehicleno as characteristics. Mileage, idletime as Keyfigures. I have created a report where i need to display the regcode as rows and mileage, idletime as columns.

But the condition is that value of mileage should be between 0 and 7999 of the each vehicles for the seperate weeks. I have specified this under condition by selecting the characteristics vehicle no and weekno.and mileage between 0 to 7999.

But the problem i am facing is the report gives the summed values of all the vehicles which does not fall between 0 and 7999.

How to go about ...Guide me...

Very Urgent...

Thanks in Advance..

Regards

Mano

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Mano,

Are you saying that it is displaying correct rows but the total is for all values? If so, select your key figure and look into the Properties section. Change the 'Calculate Results As' to summation.

Regards

Gill

former_member188325
Active Contributor
0 Kudos

Hi,do you have vehoicle number in rows? have this at first position in rows and create condition on Vehicle number.(you may hide this from display if you dont need)

Message was edited by:

Muralidhar C