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

[phaneendra_kunc]

Try sum(AmtFlag)

[jagan]

Hi,

What are the values for AmtFlag?  Are you selecting atleast one value?  If you are selecting atleast one value then you will get the results.

Try

=fabs(sum({<CYYear =, CYMonth =,Day=,TransactionDate={"<=$(vTransDate)"}>}[Cost Amount (Actual)]))/Max(AmtFlag)

Regards,

Jagan.

[SunilChauhan]

seems like only AmtFlag in denominator taking as 0  and thats why it shwoing - i.e undetermind value (when something/0)

try use below

fabs(sum({<CYYear =, CYMonth =,Day=,TransactionDate={"<=$(vTransDate)"}>}[Cost Amount (Actual)]))/

sum(AmtFlag)

hope this helps

[Anonymous]

hi thanks for reply..

the values for amount flag is

AmtFlag, AMOUNTIN

    1, ACTUAL

    1000, THOUSANDS

    1000000, MILLIONS

    100000000, BILLIONS

here 1 actual flag is always one selected..

sum(AmtFlag) and Max(AmtFlag) both are not working..

[jagan]

Hi,

Can you attach some sample file? It helps in identifying the issue.

Regards,

Jagan.

[Anonymous]

Hi jagan...

the file size too huge so it is complicate to attach sorry......

Any solution for this........

Regards

Siraj S

[jagan]

Hi,

Check this expression in text object and see whether you are getting the expected value?

sum(AmtFlag)

OR

Only(AmtFlag)

OR

Max(AmtFlag)

Regards,

Jagan.

[Anonymous]

Thanks jagan i check and update you..

[Anonymous]

Hi,

That

only(AmtFlag)

Max(AmtFlag)

sum(AmtFlag)

all these expression are not working please advice me....

Regards

Siraj