Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
i am showing closing stock and closing stock amount against Inventory posting group wise, for showing amount i am using amount flag selection for change values like thousands, millions and actual according the user selection.
i have an issue on that when i use amount flag to divide the expression for most of item no it showing value as '-' but when i select individual item it shows correct value overall it showing '-' but total is matching.
please understand the screen shot and help us to sort the issue.
=fabs(sum({<CYYear =, CYMonth =,Day=,TransactionDate={"<=$(vTransDate)"}>}[Cost Amount (Actual)]))/AmtFlag
when i remove amount flag it showing correct result.
=fabs(sum({<CYYear =, CYMonth =,Day=,TransactionDate={"<=$(vTransDate)"}>}[Cost Amount (Actual)]))
Thanks in advance
Siraj S
Hi,
Post the screen shot by adding the AmtFlag field in the dimension.
And post a sample by reducing the data