Skip to Content
0
Former Member
Feb 26, 2009 at 06:55 PM

Problems in using conditions.

18 Views

Hi all,

I have a report and I have run multiple conditions on the cumulative % of Net revenues. I have one column called Net Revenue. In 2nd column I am calculating Cumm Revenue and in 3rd Column am doing % on Cumm Net revenues.

Have to give 2 variables and depending on this report should assign titles to the records. One way is I create structure and then depending on the variables, records should get distributed within the structure, other is depending on the %age, titles should be assigned.

I am using a structure has Platinum, Gold, Silver etc

Variable X - %

Variable Y %

I have created 2 conditions for these 2 variables, X and Y. For X%, it should display only those records which meet condition X and put it under Platinum and For Y%, it should display only those records which meet condition Y and put those records under GOLD.

Problem is at atime only one condition works even if I give values to both the variables.

Any luck???

Edited by: Teder on Feb 26, 2009 9:32 PM