Doubled value

[absekrafi]

Dear Community members,

I have the exression bellow for "Quantity in Stock" in a pivot table :

if (('$(vStartDate)' <= '$(vEndDate)'),sum({<TRANSACTION_DATE= {'$(vStartDate)'}>}STOCK),0).

I am getting a value doubled for 1 product.

When I added a "table zone" to the sheet project, I got the correct value.

I am not understanding where is the mistake.

Do you have any idea where the problem is?

Thank you in advance,

Abdallah

[raman_rastogi]

Hi Abdallah

May be lke this

Sum(Aggr(sum(if('$(vStartDate)' <= '$(vEndDate)'  and TRANSACTION_DATE=  '$(vStartDate)'  , STOCK, 0)),Dim1,Dim2))

what are you getting in your subtotal? Is it wrong value or Null . Can you share  sample data with expected output .

Regards

Raman

[absekrafi]

Hi All,

I tried this : if (('$(vStartDate)' <= '$(vEndDate)') and {<TRANSACTION_DATE= {'$(vStartDate)'}>}, rangesum(STOCK),0).

The data are correct but the sub-totals aren't when there is data in more than 1 factory (Usine in the image).

Thank you,

Abdallah

[absekrafi]

When I use rangesum the data is correct but No sub-totals.

When I use Sum, data is wrong, and there are sub-totals.

rangesum( if (('$(vStartDate)' <= '$(vEndDate)') and {<TRANSACTION_DATE= {'$(vStartDate)'}>}, STOCK,0) )