Calculated Fields3

 Calculated Fields3

1.Date Difference

Output:

1.Increment and Decrement Date:

Output:

3.Look up value as of Date:

Output:

1. Sub string text:

Output:

1.Date Difference

Output:

Output:

1.Evaluate expression:Nested if conditions(Multiple conditions):

Output:

1.Convert Currency:

Output:

1.Date Difference:

Output:

Output:

Output:

1. Agree gate related instances:(Unique relationship):

Output:

1. Arithmetic calculation:

Output:

1.Concatenate Text:

1.Convert text to number:

Output:

We can't convert text to numeric. So in output it is 0.

Output:

1.Count related Instances:

Output:

Output:

1.Sum Related Instances: When RBO sum

Output:

When we migrate the data from RBO to PBO at that time we can use Extract single instance.

1.Extract single instance:

Before output:

Output:

1.Extract Multi Instance:

Output:

1.Look up related value:

Output:

1.Language

Output:

1.Date Difference