Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in a document I have a pivot chart with Year and Month as dimensions and an Amount as an expression. In a list box I have joined year with month and with recordtype. I don't want to use recordtype with a dimension but I could have temporary and definitive records. When I select the recordtype I want to calculate the sum of the amount with the selected recordtype and for year and month measure.
I have tried to use this expression, unsuccessfully: sum({$<RecordType>} Amount), but I have the sum respect of year and month dimension but not for the selected RecordType.
Any suggests to me, please?
Thanks
Hi,
the right expression would be:
sum({$<RecordType={RecordType}>} Amount),
Thanks, but it doesn't function. I have tried to put a specific value for RecordType:
sum({$<RecordType={'Def'}>})
In this way, that I don't want, I have the right sum.
Hi,
the second solution is right, you just have to define a variable which will store "record type" and use it as a reference instead of "Def"
regard
christian
Ok. I have created the variable varRecordType; when I select the RecordType I set this variable.
I have written sum( ${ RecordType = { $(=varRecordType) } } Amount), but it doesn't function.
just try:
sum( ${ RecordType = {$(varRecordType) } } Amount) or sum( ${ RecordType = {"$(varRecordType)" } } Amount)
- Ralf
None of these solutions function and there is a syntax error (where are the < and > characters?).
Is there a sure documentation about set analysis?
Sorry:
<blockquote><pre>sum( {$ <RecordType = {$(varRecordType) }> } Amount) or sum( {$ <RecordType = {"$(varRecordType)" }> } Amount)
Don't worry. I have already tried also these solutions without success!
Thanks
Ok, I've solved with sum({$< RecordType = {$(varRecordType)} > } Amount).
The variable isn't set correctly.
Thanks