Forum Discussion
ljimenezvega84
Helper I
Helper ISubstract in a dataset
Hi everyone, i got a very simple sataset just like the table below, its possible to substract a fixed ammount in only 1 GL Account? Lets says substract 500$ in the GL Account 201000?
Thanks for your help
| GL Account | Ammount | Period/Year |
| 202000 | 1.000 | 1/2025 |
| 201000 | 2.000 | 1/2025 |
| 203000 | 3.000 | 1/2025 |
| 204000 | 4.000 | 1/2025 |
You can create a calculated columnIF ( tbl[gl account] = 201000, tbl[amount] - 500, tbl[amount] )
or write a measureSUMX ( tbl, IF ( tbl[gl account] = 201000, tbl[amount] - 500, tbl[amount] ) )
2 Replies
- danextian
Super User
You can create a calculated columnIF ( tbl[gl account] = 201000, tbl[amount] - 500, tbl[amount] )
or write a measureSUMX ( tbl, IF ( tbl[gl account] = 201000, tbl[amount] - 500, tbl[amount] ) )
ljimenezvega84Thanks only need to put ¨ " in the gl account and works.
Thanks again