News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Calculated Fields Base...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

Calculated Fields Based off of Rollup Field

(1) Share

Report

Report

Posted on by Ryan N

15

Hello,

--------

--------

I am trying to add 90 days to the quarterly line, to show a Projected Date for the RR classification.

I am working with the above Switch formula in PowerApps. I am working with the above rollup field. The rollup field uses a custom column that defines today's date, but that isn't the point.

The point is, why is my calculated column not detecting the "Quarterly" and then adding the 90 days to the date it sees? I am aiming for an update to 'Prov Next RR'. Thanks!

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

Calculated Fields Based off of Rollup Field

Hi,

Are you referring to the /Proj Next RR/ field not having the correct display value when the /Review Frequency/ option set field is /Quarterly/?

In my test, the /Proj Next RR/ field can display the value normally.
I added the following field in the custom table (Test).

The result is shown below.

Best Regards,
Dengliang Li

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2

Martin Dráb 231,927 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans