News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... RSAT can't parse formu...

Finance | Project Operations, Human Resources, ...

Answered

RSAT can't parse formulas in parameter file anymore

(1) Share

Report

Report

Posted on by Community member

7

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?

All responses Img

All responses (2)

Answers Img

Answers (1)

André Arnaud de Cal... 291,684 Super User 2024 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.
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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2

Martin Dráb 230,414 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans