function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
jacek2jacekjacek2jacek 

roll-up on formula field

Hi,

I have detail object with formula field RokNow (Number) =YEAR( TODAY() )

I want to use RokNow field on roll-up sum but RokNow field does not appear on the list of field to aggergate on master object.

 

did anybody  faced similar  problem ?

Best Answer chosen by Admin (Salesforce Developers) 
PremanathPremanath

First thing the formula field we can't able do that roll-up

 

Only way to roll-up the formula field is it must and should referenced to the Another Number field or Currency field.

 

But your writng the Formula Here , Your are not referencing any Field.

 

So Roll-up doesn't calculate that formula.

 

 

Prem

All Answers

PremanathPremanath

 

I have tested it It's coming. There is no problm

May be you have done some mistake

Steps- 

-> create master detail

--> create child formula field with Number Type. 

-->Goto parant object crate Roll-up field It will appear by selecting on child object

-->goto sum radio type , Then it will appear

 

It will

 

 

Prem

 

 
jacek2jacekjacek2jacek

did you use YEAR( TODAY() ) in formula field?
PremanathPremanath

Now i have tested that Date also

 

It does not giving , Why Because , By default it takes the data type as Date.

I mean the the formula field reference to where ,,,,  That's what only it consider.

So doesn't return that.

 

 

Prem
jacek2jacekjacek2jacek

but YEAR is type NUMBER, not Date
PremanathPremanath

First thing the formula field we can't able do that roll-up

 

Only way to roll-up the formula field is it must and should referenced to the Another Number field or Currency field.

 

But your writng the Formula Here , Your are not referencing any Field.

 

So Roll-up doesn't calculate that formula.

 

 

Prem

This was selected as the best answer
jacek2jacekjacek2jacek

thank you for  replies. you are right