Create in Scriptarea the key figures (as one expression)

[beck_bakytbek]

Hi Folks,

i have a table with following fields:

Year, Account, Characteristic, Amount

2019, 4400, 4, 5

2019, 4401, 4, 4

2019, 4836, 1, 2

2019, 4937, 1, 4

explanation to above table:

the field: Characteristic consists of two values, where 4 - represents the Budget and 1 - represents the Cost.

my usse is, create within script-area one Expression, i solved this issue on userinterface with the help of set Expression as:

Sum({<Characteristic = {4}>}Amount)

Sum({<Characteristic = {1}>}Amount)

Does andyboday have any idea to this issue, namely how to create the above Expression in scriptarea? Thanks a lot in advance

Beck

[agni_gold]

Aggregate data at the script level.

[Vegar]

Something like this could do the trick.

Load

Year,

Account, 

If(Characteristic=4, Amount) as BudgetAmount,

If(Characteristic=5, Amount) as CostAmount

inline [

Year, Account, Characteristic, Amount

2019, 4400, 4, 5

2019, 4401, 4, 4

2019, 4836, 1, 2

2019, 4937, 1, 4];