I'm using CR 8.
I have several formulas that I'm copying from one report to another. All of these formulas are numeric. They represent month-to-date and year-to-date numbers at various levels of detail.
I copy and paste them one at a time. After doing so, I want to select them all and apply numeric formatting to them at the same time. The trouble is, some of them become strings instead of numbers at some point in the process of copying them. The formulas themselves haven't changed, i.e. they still return numbers. However, when I hover my mouse over them, I get the formula name plus "(string)" in the help message.
If I delete the string formulas and re-copy them, they are numeric, but now some of the formulas that were numeric to begin with have become strings.
Has anyone seen this strange behaviour or am I hallucinating?
I have several formulas that I'm copying from one report to another. All of these formulas are numeric. They represent month-to-date and year-to-date numbers at various levels of detail.
I copy and paste them one at a time. After doing so, I want to select them all and apply numeric formatting to them at the same time. The trouble is, some of them become strings instead of numbers at some point in the process of copying them. The formulas themselves haven't changed, i.e. they still return numbers. However, when I hover my mouse over them, I get the formula name plus "(string)" in the help message.
If I delete the string formulas and re-copy them, they are numeric, but now some of the formulas that were numeric to begin with have become strings.
Has anyone seen this strange behaviour or am I hallucinating?