Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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) )