showing - symbol instead of amount

[Anonymous]

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

[CELAMBARASAN]

Hi,

Post the screen shot by adding the AmtFlag field in the dimension.

And post a sample by reducing the data

100 Second Video - How to Reduce and Scramble a QVW