Liveware Publishing Support Forum

I have a totprc field which is a "total field" and I have it set on "running." Then I have a totcst field which is also a "total field" and I have it set on "running." Then I have a totgp field which is a "calculated field" and the expression is &quo...

Thanks for your reply.____However the field is a calculated field not a total field so there is an expression therefore does not give me an option to preprocess.____Is there a way to run a query on a calculated field?____Thanks again,____Linda

I have a report that I generated with R&R 9.0. The report has calculated fields, one of which taked a calculated field and calculates a total (in this case gp amount). The GP amounts can range anywhere from 100% to -100%. But I only want to retrieve those records that have a total GP amount of 2...

Worked like a charm!____Thank You.:7

Hi All,____I am trying to display a negative number in a formula. my formula goes like this: IIF(PRICE1=0,PRICE1*100,(PRICE1-COST1)/PRICE1)whichgive me 0%. I need it to display -100%. Is there any way to do this. I have tried everything.____Thanks in advance,____Linda:^(

Hi Kathleen,____Thanks for your reply. I^m not sure if I understand exactly how to achieve this but I will try. I am very new to this R & R and am not sure how to achieve the results I want. But I did have one more related question - a wrench in the wheel so to speak. Now I^ve been asked to sort...

Hi,____I^m a newbie to R&R so please bear with me. I am trying to print a report of my top 25 accounts. I ran the report & sorted it by highest sales amount. I have over 3,000 accounts. My question is, how do I print the first 25 which are my top 25 accounts?____Thanks for any help,____Linda...