Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this?
Expression:
If(Max(TOTAL Registration) = 1, Sum({<Date, CLIENT = p(CLIENT)>}Sales), Sum(Sales))
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?
Hi Pablo
This might work
= if(variable=1,sum({1}sales)),
Regards
Pratyush
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
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))
with both expressions, still the same result i had.
Would you be able to share a sample or show screenshots of what you have?
Sure, here you have a sample of my data.
please post your variable expression
Not 100% sure, but are you looking for something like attached?