Hello all,

I am pretty new to Crystal and have thus far managed to research and dev my way to a certain level, but now I ready to ask for some help.

I am doing a report and I am trying to work out on a report to work out if something is >= 5k on some financials.

I have added the data together to reach my sum and now I need to look at those figures and get crystal to work out if any of the figures in the sum are >= 5k (£5000) then I need to summary on them, thus giving me a count of all financials >= 5k (£5000)

Any help on this would be great..

Thank you

hi rkrowland,

I tried that and it didn't get me a solution

The data I have is on a spreadsheet, and I need to get crystal to look at the data and if any of the totals added up on the sheet going horizontal are >= 5000 then this needs to be flagged so I can then do the summary on them…see below the table has some data that when added up gives me a figure greater the 5k, this would then need to be added as a true.

Hi DBlank,

Thanks for you response, I am not sure what you mean, but I have done a Formula field that look like this (if {@Total of all red boxes} >= 5000 then 1 else 0)

 The total of all red boxes sum is all the data in the spreadsheet added up ({Sheet1_.M - AD Paid + F&T Paid Value} + {Sheet1_.M - TPPD Paid + TPPI Paid Value} + {Sheet1_.M - AD-Reserve + F&T-Reserve Value}) so I was hoping the report could look at any returned values and see the ones >= 5k and then flag it as a 1, then do the summary.

Is this the correct way?

Thanks

Keelan_768