Expression conditional

[Anonymous]

Hello,

I have the expression sum(sales).

i want to add the following formula if(variable=1,sum(sales)), however with this formula it only applies for the month that variable =1. i would like the expression to calculate the sales for all months if for one month the variable =1.

Thank you

[sunny_talwar]

Is variable a field here? or is it truly a variable? How does it get different values for different months if it is truly a variable?

[prat1507]

Hi Pablo

This might work

= if(variable=1,sum({1}sales)),

Regards

Pratyush

[Anonymous]

Hello,

@Sunny You are right is a dimension. The dimension gets the valor 1 showing when it started getting sales.

@Pratyush with your expression it gives me the sales when the dimension is one, but no for the following months.

thank you

[sunny_talwar]

May be this:

If(Max(TOTAL <Month> variable) = 1, Sum(sales))

or if month is the only dimension you have in the chart, then this:

If(Max(TOTAL variable) = 1, Sum(Sales))

[Anonymous]

with both expressions, still the same result i had.

[sunny_talwar]

Would you be able to share a sample or show screenshots of what you have?

[Anonymous]

Sure, here you have a sample of my data.

[vinieme12]

please post your variable expression

[sunny_talwar]

Not 100% sure, but are you looking for something like attached?