Variable

[upaliwije]

Hi Friends

I have created a varaiable as shown below

vPaid=RangeSum({<CLA_CODE={"SS"}>},LBP_CLAIMS_PAID,-EXCESS)

But this does work. Have I made any error? Kindly advise me and correct me

[upaliwije]

Sorry , This variable does not work

[jonathandienst]

RangeSum() is not an aggregation function that allows section access. I assume you mean Sum()

vPaid = Sum({<CLA_CODE={"SS"}>} LBP_CLAIMS_PAID - EXCESS)

or

vPaid = Sum({<CLA_CODE={"SS"}>} RangeSum(LBP_CLAIMS_PAID,  -EXCESS))

[tresB]

I assume you mean Set Analysis (and not section access), right?

[upaliwije]

Thanks

I have done as you suggested. But when I enter the vairavle in pivot table It returns null value as shown below

[upaliwije]

I want to create a variable "vPaid" and apply the same in an expression in apivot table

sum($(vPaid)

That is my requirement pls.

[tresB]

Try without sum() in the expression, like:  =$(vPaid)

[jonathandienst]

You can't wrap a sum() around a variable that already contains a sum. Just use $(vPaid) as the chart expression without the sum() wrapper.

[upaliwije]

Thanks Dienst,

I works that way. But I want write a another expression as shown below

({<PRL_PTY_CODE={'INP'}>}$(vPaid)) Then It does not work Seek Your advise please.

[jonathandienst]

({<PRL_PTY_CODE={'INP'}>}$(vPaid)) ??

I dont know what you are trying to achieve. As a rule, I would not convert expressions to variables until I have got the expressions working correctly. Defining variables too early makes development more difficult.