Function field function definiton

[Patrik Samuel T]

Hi,

I need to show calculated value from other fields, so I have created new functional field, but now I struggle with the function. No idea what I am allowed to put in that function definition field, since it seems to be restricted to only limited number of functions.

Goal is to show calculated annual maintenance price, hence the field type should be Currency, same as the MAINTENANCE_PRICE field.

Formula should be like (MAINTENANCE PRICE / (EXPIRATION_DATE - PURCHASE_DATE)) * 365

Any idea? Wasted so much time on this already... 😕

[2345678987]

Hi Patrik, 

I recognize everyone has unique business needs.. Why not just create an entitlement for maintenance, then populate the unit cost?