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.
Just curious :)…
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
