Chart Caluclation

[#1]

Hi Every one,

I have 5 asset classes in my chart and periods are P0 to P1, out of 5 asset classes 1 is OTC Derivative, when I make selection of OTC and Period=P0 values should be added to other periods(P1 to P15) and you can find current chart and it should be change to my requirement.

Make sure that this change should not reflect to other selections.

Current expression is: if(Trad_PRODUCT_TYPE = 'OTC Derivative',sum(Trad_UNREALIZED_PL), if(Trad_PRODUCT_TYPE = 'SFT',sum(Trad_COLLATERAL_VALUE),sum(Trad_CURR_BOOK_VALUE)))

Thanks for your help in advance.

Raj

[sunny_talwar]

I am sorry, but I don't really understand what you are trying to achieve here. When you make a selection on the Asset Class = OTC and Period =P0, what are you expecting to happen?

Best,

S

[#3]

Hi S,

For ex: P0=10, P1=20,P2=5 then if select on OTC P0 value should be added to P1 to other periods.

Like our ex: after selection(OTC) P0=10 , P1=30(P0+P1), P2=15(P0+P2).

Thank you,

[sunny_talwar]

Is this close to what you want? PFA

Best,

S

[#5]

Hi S,  Not able to open your QVW due to license, could you please help me in another way.   Thank you

[sunny_talwar · Accepted solution]

Script for reference:

Table:

LOAD * INLINE [

    Period, Value

    P0, 10

    P1, 15

    P2, 20

    P3, 5

    P4, 40

    P5, 54

    P6, 25

    P7, 20

    P8, 30

    P9, 32

    P10, 10

    P11, 15

    P12, 40

    P13, 43

    P14, 23

    P15, 10

];

Created a straight table with 2 expressions:

1) =Sum(Sales)

2) =Sum(Value) + If(Period = 'P0', 0, RangeSum(Above(Value, RowNo() - 1)))

Second expression will add P0 to everything from P1 to P15 (Snapshot attached)

Let me know if this is useful.

Best,

S

[#7]

Hi S,

Thanks for the above expression and its meaningful but in my case, I am not able to understand for my below expression.

if(Trad_PRODUCT_TYPE = 'OTC Derivative',sum(Trad_UNREALIZED_PL), if(Trad_PRODUCT_TYPE = 'SFT',sum(Trad_COLLATERAL_VALUE),sum(Trad_CURR_BOOK_VALUE)))

Thank you

[sunny_talwar]

I assume the value corresponds to one of these based on the selection (Trad_UNREALIZED_PL, Trad_COLLATERAL_VALUE, Trad_CURR_BOOK_VALUE)? If it does then you can do something like this:

If(Trad_PRODUCT_TYPE = 'OTC Derivative',

    Sum(Value) + If(Period = 'P0', 0, RangeSum(Above(Trad_UNREALIZED_PL, RowNo() - 1))), If(Trad_PRODUCT_TYPE = 'SFT',

    Sum(Value) + If(Period = 'P0', 0, RangeSum(Above(Trad_COLLATERAL_VALUE, RowNo() - 1))),

    Sum(Value) + If(Period = 'P0', 0, RangeSum(Above(Trad_CURR_BOOK_VALUE, RowNo() - 1)))))

Is this something you are looking to do? If not then I would suggest that you share some sample data so that the actual requirement can be pin-pointed.

Best,

S

[#9]

Hi S,

Thanks for the reply.

Data is huge so I can explain with screen-shot.

I have two dimensions 1. Period, 2. Trad_Exclusion_Rule(Dragged to up: 0,100,150...,). When I make selection(OTC) then P0 should be add to other periods(p1+p0,p2+p0...,). If I make selection of other Asset class and it should not affect.

my expression as above.

Your expression is not worked out:

If(Trad_PRODUCT_TYPE = 'OTC Derivative',

    Sum(Value) + If(Period = 'P0', 0, RangeSum(Above(Trad_UNREALIZED_PL, RowNo() - 1))), If(Trad_PRODUCT_TYPE = 'SFT',

    Sum(Value) + If(Period = 'P0', 0, RangeSum(Above(Trad_COLLATERAL_VALUE, RowNo() - 1))),

    Sum(Value) + If(Period = 'P0', 0, RangeSum(Above(Trad_CURR_BOOK_VALUE, RowNo() - 1)))))

Thank you

[sunny_talwar]

If(Trad_PRODUCT_TYPE = 'OTC Derivative',

    Sum(Trad_UNREALIZED_PL) + If(Period = 'P0', 0, RangeSum(Above(Trad_UNREALIZED_PL, RowNo() - 1))), If(Trad_PRODUCT_TYPE = 'SFT',

    Sum(Trad_COLLATERAL_VALUE),

    Sum(Trad_CURR_BOOK_VALUE)))

See if this one is working.

Best,

S