Hi All,
I'm trying to do a very simple calculation field but it isn't returning the correct value.
Formula:
Amount - $User.Target__c
However, it is not returning the correct values in the report:
Target Net Amount Remaining Target
2,000,000.00 | GBP 32,000.00 | GBP -68,000.00
Remaining target should be: £1,968,000
Thank you
답변 8개
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
If Target is already on the user record, then you can simply retrieve it by using Owner.Target.
You shoudl ALWAYS use the Insert Field button when creation a formula so you get the right field names. Click on it, find "Owner>", then you'll see all the fields on the User record, so you can choose Target and Insert
