Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I have the following formula. There seems to be a ')' missing. I don't see where this might be the case?
Sum({$<Month={'$(=(month(today())))'}>}
([Quantity Total Stock] * ( Distinct TOTAL <Material> ValStockValue)) / ( Distinct TOTAL <Material> [Quantity Total Stock]))
Can you please help?
Thanks
Tom
Hi @TomBond77, you are using wrongly the aggregation function. Distinct and TOTAL modifiers can only be used once. I am not sure if you are trying to use more aggregation functions or a special calculation inside the Sum. For example, this should be syntactically correct but I think this is not what you want:
Sum(
{$<Month={'$(=(month(today())))'}>}
Distinct TOTAL <Material>
([Quantity Total Stock] * ValStockValue)
/
[Quantity Total Stock]
)
JG