Calculate column

[Daniel1908]

Hello Together, 

is it possible to calculate different column?

For example count  if Price3 ist not Price1 + Price2 and ReturnLabel A

Count(aggr( only(distinct{<ReturnLabel={"A"},[Price3]-=[Price1]+[Price2]>} Material Number) 

Kind Regards, 
Daniel

[jwjackso]

=Count(If(Price3=Price1+Price2 and ReturnLabel='A',[Material Number]))

[Daniel1908]

This works thanks. 

Now I wanted to add my variable to the formula. 
This worked for the Count function, how do I add this correctly to the count(if function?

{<[LoadDate.Quarter]={'$(var_SelectedYear)'},

Kind Regards, 
Daniel

[jwjackso]

=Count(If(Price3=Price1+Price2 and ReturnLabel='A' and [LoadDate.Quarter]=$(var_SelectedYear),[Material Number]))

Test the $(var_SelectedYear) with and without single-quotes

[Daniel1908]

The Formula shows OK with single quotes, but the Load Date does not work. 

[jwjackso]

In the bottom left of the expression editor, verify how the $(var_SelectedYear) is being expanded.  Does it match the values in [LoadDate.Quarter]?

[Daniel1908]

I doublechecked it.

It is correct, it works for the other formulas on the same Page. 

Any further ideas?

Thanks for your help.