Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorry , This variable does not work
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))
I assume you mean Set Analysis (and not section access), right?
Thanks
I have done as you suggested. But when I enter the vairavle in pivot table It returns null value as shown below
I want to create a variable "vPaid" and apply the same in an expression in apivot table
sum($(vPaid)
That is my requirement pls.
Try without sum() in the expression, like: =$(vPaid)
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.
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.
({<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.