need help on formula field

(0) Share

Report

Posted on by EKL

Hi,

I am converting formula field from Salesforce .Below is the formula,

IF(DATEVALUE(CreatedDate) = DATEVALUE(Completed_Date_Time__c),
(Completed_Date_Time__c - CreatedDate) * 24,
((CASE(MOD(DATEVALUE(CreatedDate) - DATE(1985,6,24),7),
0 , CASE( MOD(DATEVALUE(Completed_Date_Time__c) - DATEVALUE(CreatedDate) ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),
1 , CASE( MOD(DATEVALUE(Completed_Date_Time__c) - DATEVALUE(CreatedDate) ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),
2 , CASE( MOD(DATEVALUE(Completed_Date_Time__c) - DATEVALUE(CreatedDate) ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),
3 , CASE( MOD(DATEVALUE(Completed_Date_Time__c) - DATEVALUE(CreatedDate) ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),
4 , CASE( MOD(DATEVALUE(Completed_Date_Time__c) - DATEVALUE(CreatedDate) ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),
5 , CASE( MOD(DATEVALUE(Completed_Date_Time__c) - DATEVALUE(CreatedDate) ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),
6 , CASE( MOD(DATEVALUE(Completed_Date_Time__c) - DATEVALUE(CreatedDate) ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),
999)
+ (FLOOR((DATEVALUE(Completed_Date_Time__c) - DATEVALUE(CreatedDate))/7)*5)
- 2) * 9)
+
MAX((
DATETIMEVALUE(TEXT(YEAR(DATEVALUE(CreatedDate))) & "-" & TEXT(MONTH(DATEVALUE(CreatedDate))) & "-" & TEXT(DAY(DATEVALUE(CreatedDate))) & " 01:00:00am") - CreatedDate + 1) * 24, 0))
+
MAX((Completed_Date_Time__c -
DATETIMEVALUE(TEXT(YEAR(DATEVALUE(Completed_Date_Time_c))) & "-" & TEXT(MONTH(DATEVALUE(Completed_Date_Timec))) & "-" & TEXT(DAY(DATEVALUE(Completed_Date_Time_c))) & " 16:00:00pm")) * 24, 0)

How to convert in Dynamics Crm.??

Using Formula column from Powerapps there is 1000 characetrs limit??

Thanks

I have the same question (0)

All responses (4)

Answers (0)

Guido Preite 54,086 Moderator on at

Like (1)

Report

what this formula does exactly?

Was this reply helpful? Yes No
EKL 10 on at

Like (0)

Report

Thank you Guido ,We don't have much info as of now but it is calculation based on created date and completed date fields and some other logic which is not understandable.

So I tried to replace Switch in place of CASE ,Date in place of DATEVALUE etc but limitation of 1000 characters is coming in Formula column of powerapps.

Was this reply helpful? Yes No
Guido Preite 54,086 Moderator on at

Like (1)

Report

without knowing what the formula is doing exactly you will not be sure also if you convert the code. Try to understand what the formula does exactly (there are salesforce communities like salesforce.stackexchange.com/ ) and after you have the logic converting to dynamics will be easier for you

hope it helps

Was this reply helpful? Yes No
Leco Lv on at

Like (0)

Report

Hi partner,

The dynamics 365 formula column is using power fx. As Guido suggested, after you know exactly what the formula does, you can come back to this case to list your needs or open a new case.

Was this reply helpful? Yes No

Join the conversation

Community site session details

need help on formula field

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

need help on formula field

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates