Webi : Condtions doesnt work on aggregated level

[former_member555797]

I have a scenario with below outcome but business wants certain conditions on report such as: Exclude "Traffic Total" where its 0 or null (Works) and exclude rows where 'Gross ticket conversion" is more then "Traffic Total". I made filter on 'Traffic Total" not equal to 0 and made a variable (=If ([CSRvc Total Tickets]<[Total Traffic]) Then [CSRvc Total Tickets] Else 0) works only when I use calendar days but if I remove calendar days and choose only Site and week than the condition variable does not work because on aggregated level it doesnt work. I am using bex connection to webi.

Results as it is:

Results afer applying filters and creating new variable:

Results after removing calday:

[amitrathi239]

create dimension variable for Traffic Tot and Gross ticket conversion objects and then try to filter out.

[former_member555797]

This works only if calendar day dimension is selected, if i remove calendar day and use calendar week then it does nt work because it aggregates all the data on week. Traffic and tickets are CKF in bex and use standard aggregation. Is there any possible way that we can put condition in a detail level per day so that even it aggregates on week level than it shows same numbers.