Sum Error - Mismatch

kpeters

Hi,

I am attempting to bring in the sum of one line item from one module to the next and getting the error:

Data type mismatch: format other than LIST or DATE being referenced as a relation

Here is the formula that is failing:

and the referenced module:

Thanks!

Accepted answers

All comments

Puneeth H P

Hi @kpeters

By the looks of it , I think you should be creating a line item which finds the list item using Text formatted like item Cust.Mkt ID .

Then you can use this line item in SUM to bring the SUM by the list .

Hope this helps .

Thank you,

Puneeth HP

ashish.banka

@kpeters Looks like in the Source module "D11 Journal Manual Entries", you are trying to group "Text" formatted line item " Cust.Mkt ID". If Customer is one of the List in the model and MKT ID is a property or code of Customer List, you can use "FINDITEM()" to find the List Member in a Customer List formatted line item and refer that in SUM:

Hope this helps.

abhi1017

Hi @kpeters

The reason for this error ("Data type mismatch: format other than LIST or DATE being referenced as a relation") , the line item using which you are trying to sum is a text formatted rather date or list.

In order to sum here:

1. Create another lineitem name it Cust.Mktlist and format it by Cust.Mkt list

2. Formula for Cust.Mktlist :- Finditem('Cust.Mkt',Cust.Mkt ID)

3. Now use this lineitem "Cust.Mkt list" in the sum formula.

Hope this helps.

~ABhi

ChrisAHeathcote

@kpeters

The error is generated because you are trying to use a text formatted line item to map between lists.

SUM only works when you are able to use a relationship between two lists and a list formatted line item is used in the formula.

Create an additional line item and format this as the target list to be used in the SUM. Use the code in a FINDITEM function to pull through the relevant list item.

=FINDITEM(Cust.Mkt (this is referencing the list whose ID you are pulling through), Cust.Mkt ID)

If you use this in your SUM formula you should not generate the same error.

kpeters

Should I be adding the Finditem to both modules and then using the Sum function?

Thanks!

SandeepB

@kpeters,

You just need to have list-formatted sum criteria in your "D11 Manual ** " Module.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SUM.html

Thanks,

Sandeep

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…