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.
We would like to ask about an issue with the Intercompany Matching Report. We have executed intercompany matching; however, the results are not being reflected correctly in the report. We have outlined the steps we implemented below and would appreciate it if you could advise whether anything is missing or incorrect in our…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
This item has been identified as an outstanding known issue. Issue Setting a current page filter or sort and then exporting this data to file, will apply the current page filter/sort to all pages of the data. Workaround Remove all filters/sorts, export the data, and apply the filters/sorts in Excel --- Internal Reference:…
