cancel
Showing results for
Did you mean:
Regular Visitor

## Modelling Issue

Good Evening experts,

I have modelling issue. I have claims table which has only 4 models but in my sales I have 6 models. Part of the formula is to calculate the count of claims and divide it by Total sales. Which is not producing the right results as counts are for 4 models from claims but we are diving it sales total of 6 models. If someone can point me in right direction that will be greatly appreciated.

Here is the link to the sample file

Modeling Issue

Thanks in advance for the help.

8 REPLIES 8
Community Support Team

## Re: Modelling Issue

I have modelling issue. I have claims table which has only 4 models but in my sales I have 6 models. Part of the formula is to calculate the count of claims and divide it by Total sales. Which is not producing the right results as counts are for 4 models from claims but we are diving it sales total of 6 models.=

What does 4 models and 6 models mean? In the sample you post, there're 7 tables and one page report. Could you clarify more details about the logic and show the expected result?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regular Visitor

## Re: Modelling Issue

If you look in the claims file. You have NP0, NQF, NQG and NQH models that have claims. Its the "model" field in claims table.
But if you look at sales converted data under "Model" field It will show NP0.NQ^,NQ&,NQF,NQG and NQH. So when I run the Sales sum it sum all the models that are in the sales and return the number I just want the total of sales from sales for only the models that are in claims table.

Regular Visitor

## Re: Modelling Issue

Anyone can help in this regard?

Regular Visitor

## Re: Modelling Issue

As you can see that total claims only have 4 models but it is calculating sum of sales for 6 for total sales.

Any help will be greatly appriciated.

Established Member

## Re: Modelling Issue

I don't think you've attached the correct file in the first post.  All tables only have one model 'JK'

Regular Visitor

## Re: Modelling Issue

Correct Modeling file

Thank you, was probably having a brain fart. Thank you for pointing it out.

Established Member

## Re: Modelling Issue

You will have to create a visual by using the Models table since it links Claims and Sales.

There is a problem with this table because it doesn't have 'NQH' model.

Highlighted
Regular Visitor

## Re: Modelling Issue

@HotChilli  Thank you . I am not sure how to create the measure for sales that only sum all the models in sales For the models claim have.  Here is the latest file again. THank you for pointing out the silly mistakes, its unfortunate I cant share the real data I have to create dummy data.

Models Fixed