TM1 Forum

I agree and changed it back. Easier to understand and pleases the symmetry part of my brain.

PS... Fully agree and appreciate your hero statement.

The only other thing I did was to change '%' | 'pAdd' to '%pAdd' since it was concatenating two strings directly next to each other. Though honestly I liked the symmetry of yours so I might go back just so it looks prettier. Final version: sCurrentParam = Expand('%pAdd' | NumberToString (Counter) | ...

Awesome! You're my hero of the week.

Do you prefer STR over NumberToString? Fewer parameters and no need to TRIM, I would think.

Many thanks,
Benjamin

It might help to understand if you're working with TI process, a Planning Analytics Workspace (PAW) view, a dynamic report in Planning Analytics for Excel (PAX), or somewhere else. For better or for worse, I have created quite a few dynamic views in PAW and PAX over the past week and can probably he...

I am trying to provide users with the ability to add up to 20 elements (employees) to a particular cost centre. I am passing the parameters from Excel but I have also run the process manually and filled in a test element name and test caption and the result is the same. I am attempting to use a WHIL...

This isn't the perfect place to post my solution; however, the screenshots above perfectly described my situation after installing TM1 10.1.1 FP1 and searching here for a solution. My websheets were created when running TM1 9.5.2 FP2. My values and number formats were coming across just fine but the...