asked on August 20, 2021
Hello support team,
Please, explain to me this behaviour is normal?
1. I created a calculated value, where the formula is "sum('Price') + 200" and the name is "new price" (1.png)
2. I set the row in the table - "producted code" (2.png)
3. Then I double click on SR144(3.png), I see that the name field is "Price" (but I wait "new price") and the cell 991 (need 1191)
Thank you for your time.
Best regard,
Artsem
⋅ August 20, 2021
Hello,
Thank you for posting on our forum.
Please note that the specified formula is applied over aggregated values. In your case, the sum of all prices is associated with the SR144 product code. Let's say two records are related to this product code: 50 and 70. In this case, the resulting value would be calculated as the following: (50 + 70) + 200.
User "Calculate individual values" checkbox or individual property to calculate formula based on raw values: (50 + 200) + (70 + 200). Please note that this feature is only available for JSON and CSV data sources.
Concerning the drill-through view itself, its primary purpose is to display raw data used to compose the clicked cell. Although the formula modifies values, drill-through serves only to show original values without any calculations were applied.
We hope it helps.
Kind regards,
Illia
