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.
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…
