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.
I have this error message " Azure blob http error " when i save cloudworks connection to Blob Storage. I follow this link: Connect to Azure Blob | Anapedia Can someone help to identify the root cause and how to resolve? is it related to permission or security?
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
