on 12-22-2016 3:48 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.