In count relationship, only one parameter is passed and it returns the number of entries of the relationship subpanel of that data. For example - If we pass count_relation(leads) in the formula then it'll show the number of entries of the lead subpanel of that data.
In
Sum of relate fields ,firstly we select a subpanel field that can be contacts, opportunities.The options in related field are integer type fields of the selected module. If you want to sum the data present in integer field of subpanel and show that data in the field of module then it can be used.
For example- I want to create a field in account module which shows the sum of amount of opportunities present in subpanel field then I will use the formula-
sum_relate(opportunities,amount).
Yes , there is an option "Diff Month Now" in which only one parameter of date type is passed.
Like diff_month_now(date) and it shows the difference in terms of month from the today month and the month of the date field.
Hi
yes, it is possible.
For this there's an option in dropdown "Diff Month" in which two date parameters are passed and it returns the difference of the months.
Like diff_month(datetoday, datenew) diff_month(01/01/2022, 03/02/2022) then it will return 2 months.
If you want to add n number of months in any date then the correct format is -
add_month(datetoday,6 months) where datetoday is a date field. If you will pass just numeric value as second parameter like add_month(datetoday,06) then it will show "Wrong format,Format: 00 months".
Hi Heiko,
Thanks for your request,
As this is a formula field and if you want to increase the limit of that field, you can do it by altering the concerned table column limit.
Hi,
As the calculated field having a currency datatype, You can add a calculated field type currency and in the label, you can add the £ symbol to that field name at the time of creation.