topic Re: Calculate column in App Development

Calculate column

Daniel1908 — Thu, 01 Apr 2021 14:18:49 GMT

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 — Thu, 01 Apr 2021 14:43:07 GMT

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

Daniel1908 — Thu, 01 Apr 2021 15:23:26 GMT

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 — Thu, 01 Apr 2021 15:32:29 GMT

=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 — Thu, 01 Apr 2021 15:45:55 GMT

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

jwjackso — Thu, 01 Apr 2021 15:51:38 GMT

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 — Thu, 01 Apr 2021 17:47:26 GMT

I doublechecked it.

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

Any further ideas?

Thanks for your help.