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
Try sum(AmtFlag)
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.
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
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..
Hi,
Can you attach some sample file? It helps in identifying the issue.
Regards,
Jagan.
Hi jagan...
the file size too huge so it is complicate to attach sorry......
Any solution for this........
Regards
Siraj S
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.
Thanks jagan i check and update you..
Hi,
That
only(AmtFlag)
Max(AmtFlag)
sum(AmtFlag)
all these expression are not working please advice me....
Regards
Siraj