RSAT can't parse formulas in parameter file anymore

(1) Share

Report

Posted on by Community member

Hi everyone, I have several test cases in whose parameters I should put some dates; I'm trying to generate 'em with the formula =DATE(YEAR(TODAY());MONTH(TODAY());1)
but when I generate the test execution file, it gives me a processing error about the parameters file cell where I've put the formula.
Are there still unsupported functions? Is this a RSAT bug or whatever? My formula seems to be correct since Excel evaluates it flawlessly.
Is there a new way to give formulas as parameter values?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community member 7 on at

Like (0)

Report

RSAT can't parse formulas in parameter file anymore

RESOLVED: it's mandatory to put an apostroph (') before the 'equals' sign (=) introducing the formula, otherwise PowerFX doesn't parse it.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,731 Super User 2025 Season 2 on at

Like (0)

Report

RSAT can't parse formulas in parameter file anymore

Thanks for providing your answer. I marked your answer as verified to set the status of this question to Answered.

Was this reply helpful? Yes No