Medical Costs-Cert Question

ciara
ciara
in Academy Discussions

Hi,

 

I have trying to complete the Medical costs for 2 days now and I can figure it out. I created the list of roles:

ciara_0-1591723567178.png

Created EMP003 Employees-imported employees by roles data

ciara_1-1591723627802.png

Added Roles to SYS08 then imported the txt:

ciara_2-1591723693664.png

I try to amend the formula to take in EMP003 annd SYS08 Roles 

Medical costs -  IF Employed? THEN 'EMP003 Employee Drivers By Role'.Medical[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

 

It keeps failing saying format of mapping used for lookup doesnt match any dimension of the source

 

 

 
 

 

 

 

 

 

Tagged:

Comments

  • Kanishq17
    Kanishq17

    hi @ciara 

    what is the target module where you are entering this formula,

    it seems formula is correct as source contains e1 dept and role and mapping also maps to them, just ensure the dimensions are same

     

     

  • ciara
    ciara

    @Kanishq17 

     

    Its the cert Q4 to get the medical Costs. I have tried this for 2 days different ways so I must be missing something 

  • Kanishq17
    Kanishq17

    @ciara 

     

    Can you attach a snip of the employee driver by role, sys employee details and the module where you are entering the formula

     

  • ciara
    ciara
    The imports is it?
  • ciara
    ciara

    Of the excel/text like the imports?

  • Kanishq17
    Kanishq17

    @ciara 

    Yes, and where in the model are you loading the file

  • ciara
    ciara

    ciara_0-1591786687764.png

    I am loading this into EMP003

    ciara_1-1591786830529.png

    and the txt file to SYS08

    ciara_2-1591787035783.png

    imported to As 

    ciara_3-1591787102503.png

     

  • Kanishq17
    Kanishq17

    hi @ciara 

    the data is loading correctly I suppose as the mappings look good, can you show the module snip where you are applying lookup to refer value from EMP003 module based on SYS08 mappings, also are values coming for other cost like phone etc?

     

  • ciara
    ciara

    ciara_0-1591791971405.pngciara_1-1591792036712.png

    It is the same for all costs

  • Kanishq17
    Kanishq17

    hi @ciara 

    it is not mapping issue, it is a syntax error in the formula, before EMP003 there are double quotes, it must be single quote ,

    it shouls be 'EMP003..' but yours is showing "EMP003..' , correct the syntax, it should work fine

     

  • ciara
    ciara

    Oh thank you.... simplest thing!! thanks 

  • jaboitizb
    jaboitizb

    Hi @ciara, Im stuck in the same place as you were. Keeps saying "Data type mismatch: format other than LIST or DATE being referenced as a relation". Please help

Categories