Combine 2 Formulas

[#1]

Hello together,

i have to formuals

sum({$<Nature={Actual}>}€)

and

Sum({<[year]={$(vYTDYear)} >}[€]))

vYTDYear = (max(year))

My Suggestion is

sum({$<Nature={Actual}>} <[year]={vYTDYear)}>}

Can you help me.

Thanks

[phaneendra_kunc]

Use this

sum({$<Nature={'Actual'} ,[year]={$(vYTDYear)}>}[€])

[#3]

Hi,

try this:

Sum({$<Nature={'Actual'},year={$(#=vYTDYear)}>} [€])

$(#=) means QV has to read your variable as a Number.

Best regards

[mrooney]

I think you are right. This expression should be enough.

[#5]

Hello,

it Shows me the follow sign '-' in the table.

Do you know, why?

[#6]

thank you, but it Shows only the value '0' in the table.

Do you have an other idea?

Thanks.

[phaneendra_kunc]

Howz your max year variable was setup? Do you have equal sign in front of the expression in variable?

if yes use the expression I have posted above.

it will be easy if for us if you can share your sample QVW.