cancel
Showing results for 
Search instead for 
Did you mean: 

Running total based on 2 Fields in Crystal reports

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

abhilash_kumar
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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?

former_member292966
Active Contributor
0 Kudos

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

abhilash_kumar
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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