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