Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
is it possible to get the 20 (out of 53) Weeks ready for a calculation?
I only see, right now, with green weeks as follows:
that it is only possible to GetPossibleCount(Woche) = 16.
Whereas I would be very glad to have 20 for further calculations.
Any idea?
Thanks in advance,
Wolfgang
It appears to me as a impact of your selections in Herkunft and in the field below it as shown in your current selection box.
In your calculation if you disregard selections in those fields using Set analysis by using <Fieldname=; in the set expression, you should get 20 weeks for your calculations.
Woche 1-5 hat keine Daten hinterlegt, deshalb mit grauem Hintergrund.
Mit GETCURRENTSELECTIONS() und max-values auf 20 (oder 50), solltest Du die richtige Anzeige hinbekommen.
Peter
Vielen Dank, Peter,
leider erschließt sich mir max.... Anfänger nicht wie das geht oder wie Du das gemeint hast mit
max-values auf 20
Wolfgang
getcurrentselections ([RecordSep [, TagSep [,ValueSep [, MaxValues
[, State]]]]])
Returns a string with the current selections in the document. It is possible to query an alternate state.
RecordSep is the separator to be put between field records. The default is <CR><LF>.
TagSep is the separator to be put between the field name tag and the field values. The default is ': '.
ValueSep is the separator to be put between field values. The default is ', '.
Maxvalues is the maximum number of field values to be individually listed. When a larger number of values
is selected the format 'x of y values' will be used instead. The default is 6.
Ähnlich mit
getfieldselections ( FieldName [, ValueSep [, MaxValues [,
State]]])
Returns a string with the current selections in a field. It is possible to query an alternate state.
ValueSep is the separator to be put between field values. The default is ', '.
Maxvalues is the maximum number of field values to be individually listed. When a larger number of values
is selected the format 'x of y values' will be used instead. The default is 6.
Die Rückgabe kannst du dann mit String-Funktionen weiter auswerten.
z.B.: SUBSTRINGCOUNT(GETFIELDSELECTIONS(Woche, '|', 100), '|') +1
Peter
edit: Stringfunction added