Calculation

[has75042]

Hi All,

When I select fiscal year and fiscal period 1-9 as a group I get a total of 3,596,680. However, when I select  fiscal year and fiscal period 1-9 are selected individually, they total 4,157,575. Please let me know how I can fix this issue

My expression is:

=sum(cash_price)

[sunny_talwar]

Not sure I follow the difference in selection... what do you mean when you select fiscal year and fiscal period as a group?

[chrismarlow]

Hi,

Maybe a duplicate somehow between your dates and your facts (assuming you have a date table separate).

Can you post an image/values for a straight table with fiscal_period/year as dimensions and sum(cash_price) as expression?

Cheers,

Chris.

[has75042]

for example

fiscal year 2019

fiscal year 1-9 all at once

[has75042]

when you add all them in excel total comes upto be 4,157,575.00

[chrismarlow]

Please can put a picture of your data model (control-t) should do it.

Cheers,

Chris.

[has75042]

[chrismarlow]

Hi,

I think you have a buyback_id that appears with more than one Dateonly - where the date then sits in a different fiscal period/year.

So I can create a toy model with similar structure & make the data do that (attached, but I am on personal edition) and so come up with a non summing straight table (left);

Possibly you could add something like the grid on the right & see if you get count distinct>1?

Cheers,

Chris.

[has75042]

Chris,

Somehow I can't open this QW

[has75042]

You are right it does show in two fiscal period. Is there a way to fix this issue