Skip to Content
avatar image
Former Member

Running total based on 2 Fields in Crystal reports

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 22, 2016 at 07:40 AM

    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

    Add comment
    10|10000 characters needed 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

  • Jan 24, 2017 at 05:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25, 2017 at 07:42 AM

    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

    Add comment
    10|10000 characters needed 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?