Search results for query: *

Thanks mate. Group selection is perfect. Thanks for your help.

Your formula is working perfectly, but one help oly the sum of LCY line is getting suppressing not the whole record Eg; BOM 2300000 BLR 2200000 LCY 1000000 So only LCY is getting suppress not the whole record.

If i want to add a formula in section supression then how it would be.

Hi, One more doubt in my report i have to report negatvie values also which should be greater than 500000. That means my report should show the output > 500000 (negative and positive values) Thanks.

Hi, 1 doubt should i remove my previous formula and then apply a group selection formula.

Hi, The formula is showing correct details, Now i just want to supress the false records, that means only LCY > 500000 records should be appear. Thanks.

lbass, Sorry for late reply, The report is sorted on Group No, so, I just want a formula where i have to just add a field next to LCY Balance to show that wheather True if balance is greater than 500000 So as per your formula, i will create a new formula where i will type: if sum({table.LCY...

Thanks for your reply, I just need a true or false query as i dont need to supress the records, I just want show True if the sum of LCY is above 5,00,000.00 or false, I just want to apply if-else formula on sum condition

hi, I have a report in which i have to show the sum balances of greater than 5 Lacs , I want to apply an if-else query on Sum How to create a formula of If-else on sum condition. I have given my query formula please make the requirement changes. =if(sum of LCY Balance) > 5,00,000.00 "True" else...

There is no main report. There are 4 subreports. The multiple totals are sum of each city.

Hi, In my report there are 4 city wise subreports which give respective balances. Scenario; In all subreports there will be multiple city wise totals such as BOMBAY, DELHI..etc I need all those balances in a grand total. Kindly help

Between the lcy balance and fcy balance there is a one formula called FCY code. the formula contains if{ib600mb.pfd_account_ccy}="INR" then "fcy" else {ib600mb.pfd_account_ccy}

1) Select expert 2) Select new 3) Select the cloumn which contains those numbers(09 71526.. etc,) 4) Click the dropdown button, select the "not equal to" 5) Add those excluding numbers and click ok.

There is no formula both are separate feild, there is no conversion formula too.

Turkbear, Thanks for your feedback. My requirement is whenever above scenario occur the difference feild should tally, but it doesn't tally due to different foreign currency rate taken by LCY Balance automatically. Eg, FCY = rs 49 LCY= rs 48 I just want that LCY should also be rs 49.

Just right click the FCY_Balance then select dropdown of show zero value as select -, when you run the report where-ever it shows zero it will show you -(dash), it will not affect the LCY_Balance too. Thanks lbass for your knowledge.

I want to overcome a crystal report situation,In my report there are two main fields, LCY_Balance and FCY_Balance, When i run the report.. It shows this scenario. FCY_Balance LCY_Balance GCB $5 RS. 250 LCY $5 RS. 249 Difference: 0...

Thanks, the problem is sorted out.

lbass, Did'nt get the copy the selection formula part, Kindly help.

lbass, I have used not equal to zero in fcy balance in expert & also used your formula but still zero is coming. Kindly help and thanks for guidance.