Skip to Content
0

Running total based on 2 Fields in Crystal reports

Dec 22, 2016 at 03:48 AM

48

avatar image
Former Member

Hi All,

Could you please someone guide me to resolve one issue ? I have 4 fields i.e Buy Currency, Buy Amount, Sell Currency, Sell Amount. Created a running total to split by Buy Currency and I want to split running total by both Buy and Sell Currency. Thanks

Ex: 1 (Working fine)

Eur 10000 MYR 2000

10000 2000

JPY 2000 EUR 2000

2000 2000

Ex:2 ( Not working)

Eur 10000 MYR 2000

Eur 2000 JPY 2000

12000 4000 and Sell Currency values are not taken. Let me know if you are not clear on my example

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Abhilash Kumar
Dec 22, 2016 at 07:40 AM
0

Hi Singarayan,

Could you please elaborate on

Created a running total to split by Buy Currency and I want to split running total by both Buy and Sell Currency

The dataset posted above doesn't really explain what the current and expected output is.

-Abhilash

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Abhilash,

It has been resolved now and need assistance for my below query. I have created a formula as below. But the results show in Boolean. I want it in a number. Kindly assist. Basically want to display numbers in Negative/Positive.

({vrpFXValnContracts.BuyFXFwdRevalLocal}+{vrpFXValnContracts.SellFXFwdRevalLocal}) < 0

0
Brian Dong Jan 24, 2017 at 05:34 PM
0

Hi Singarayan,

The formula is returning a boolean because of the < 0. You're comparing the rest of the formula to 0 so Crystal is telling you either yes it is < 0 or no it isn't < 0.

Brian

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Jan 25, 2017 at 07:42 AM
0

Hi Singarayan,

Remove the <0 part in the code, like so:

({vrpFXValnContracts.BuyFXFwdRevalLocal}+{vrpFXValnContracts.SellFXFwdRevalLocal})

Next, drag and drop this formula fied on a section > Right-click > Format Field > Number tab > Choose a format that also have negatives.

-Abhilash

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Abhilash,

I Have a question,

I have a report i want to show my report hear in "even" or "1,5,10,15,....like pages only how it is possible can you give me the answer?

0