My visual is kinda like this. However, for those with formula, i need to use that text to calculate the value for budget_amount.
For example, BH10’s budget_amount is calculated using budget from BAZ2+BS1Z-BP1Z.
Is it possible to write a calculated field that use the text from formula field to calculate budget_amount? If possible, please tell me how to do it. Thank you so much!
Hi @Kuroha - For each item, if you have a different formula, you can explore if else approach but this is not recommended, better to do this calculation at ETL or outside QS level.