after inputting the formulas they get this,
but i get a blank for the line items starting from bonus to medical costs and TEE is computed wrong for me without adding the rest as shown below,
below i have uploaded the blueprint version also,
@vyshnavsk
Did you reload the data in SYS08 Employee Details after you changed the format for Country?
What are the formats of Department and Country in Employee Details?
@rob_marshall for department it makes me choose E1 departments lists since its not allowing other formats and for country its text.
Look at Country, the format is TEXT and should be list formatted. You can only do lookups on list formatted line items and Time.
@rob_marshall
okay, but having changed the country format to list, it still shows the same,
yes, thanks a ton it worked
When you ask a question, please remember to mark the response as Answered…Also, I would caution you against marking responses as Rejected Answer as you did above as that is the true answer (a lookup can't be performed on a Text formatted line item).
Rob
Oh I am sorry, i unknowingly must have marked that.
what are these? when do you use them? why one over another? thanks Data types string long float bool date datetime datetimetz
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-
