on 08-05-2020 7:59 AM
I am working on a story with calculated measure. I tried to convert negative value to positive with condition, but it's not working. the data was from hana live connection. Formula written as:
IF([d/"PUR_FACT_IP_VALID_SR":commodity_code]="X047", ABS(["PUR_FACT_IP_VALID_SR":act_value_rmb]), ["PUR_FACT_IP_VALID_SR":act_value_rmb] )
Could anybody help to explain if there's anything wrong in the formula?
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.