Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm new to QW and have a straight table that sums the the cost of of all products over time. My question is if i somehow can enter a condition that lets me filtrate out all data for the sum(cost) expression below or above a sertain value, for example to only show all products that have a value of more than 300.000 and less than -300.000 in the straight table and what that expression would look like?
Best regards!
hope this is what your looking for
Try this:
If(fabs(Sum(Cost)) > 300.000, Sum(Cost))
hi try like this:
if(sum(cost)>300 or sum(cost)<-300, sum(cost))
hmm, cant get it to work, the deffinition looks like this:
({<Year={$(vYear4)},Quarter={$(vQuarter2)}>} Cost) - Sum({<Year={$(vYear3)},Quarter={$(vQuarter1)}>} Cost)
It calcs the variance between different quarters and i only want the <300.000 and <-300.000 values to show.
Hi Hampus,
apply the condition on the whole set of expression:
if(sum({<Year={$(vYear4)},Quarter={$(vQuarter2)}>} Cost) - Sum({<Year={$(vYear3)},Quarter={$(vQuarter1)}>} Cost)>300 or
sum({<Year={$(vYear4)},Quarter={$(vQuarter2)}>} Cost) - Sum({<Year={$(vYear3)},Quarter={$(vQuarter1)}>} Cost)<-300,sum({<Year={$(vYear4)},Quarter={$(vQuarter2)}>} Cost) - Sum({<Year={$(vYear3)},Quarter={$(vQuarter1)}>} Cost))
Can you please share your app
Try this:
If(fabs(Sum({<Year={$(vYear4)},Quarter={$(vQuarter2)}>} Cost) - Sum({<Year={$(vYear3)},Quarter={$(vQuarter1)}>} Cost)) > 300.000,
Sum({<Year={$(vYear4)},Quarter={$(vQuarter2)}>} Cost) - Sum({<Year={$(vYear3)},Quarter={$(vQuarter1)}>} Cost))
Best,
Sunny
Think i'm doing something wrong, it wont sort out the above or below values. Can't share the original files but made a mini-version of the original with very limited data but it shold roughly show what i wanna do. The values in this data dosen't come close to 300000 as a limit but anyways:P
hope this is what your looking for