Calling expressions

[#1]

I am trying to make this work:

(Sum (if (Belåningsgrad <= 0.6, tot_engasjem))+ sum(under_60))*0.05

Where under 60 is a an expression that I have calculated earlier, it comes up in blue colour so I thought I could use it. However it dosen't seem to work as planned

[#2]

I don't know how "under_60" is defined, but you can try:

(Sum (if (Belåningsgrad <= 0.6, tot_engasjem))+ sum($(under_60)))*0.05

[#3]

My 'under_60' is defined as

Sum (if (Belåningsgrad <= 0.6, tot_engasjem))

[#4 · Accepted solution]

Hi kiteulfen99,

The problem is the sum within the sum. Say you have dimension [country].

The expression that is worked out previously, "under_60" is for that [country]. You are then trying to sum it again within [country], it will not work. Basically it is like writing sum(sum (if (Belåningsgrad <= 0.6, tot_engasjem))) within that expression,

What is the result that you are aiming for? Perhaps you could try aggregated expressions or totals to evaluate the sum(over_60) over different dimensions or

You could leave it as

(Sum (if (Belåningsgrad <= 0.6, tot_engasjem))+ under_60)*0.05

Let me know if you would like me to explain further,

Regards,

Erica

[#5]

Why dont you try to use the column function, I used before and works fine. Ex:

=(Sum (if (Belåningsgrad <= 0.6, tot_engasjem))+ column(1) *0.05

[#6]

Yes thanks Erica,

That did the trick. However my expression is now

(Sum (spob_engasjem)+ under_60)*0.05 now it remains to just put in all the other expressions . But hopefully I will manage to do it.

Best

Kiteulfen

[#7]

You're welcome!

Regards,

Erica