🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Filtered values in calculated values

Mark Waller asked on June 1, 2021

Is it possible to filter the fields in a calculated value?
We have field which is product, I want to make a calculated value which what percentage of overall product usage comes from a particular product over time.

3 answers

Mykhailo Halaida Mykhailo Halaida Flexmonster June 2, 2021

Hi Mark,
Thank you for posting your question.
Could you please describe in more detail, maybe with an example, the behavior you’re trying to achieve? 
Having your report configurations would also help us understand your situation better, if possible.
Looking forward to your response.
Best regards,

Tom Ray June 2, 2021

We have the same need. 
i.e. Transient rooms = sum of rooms where market = Transient
Market is a Report Item
rooms is a measure 
Putting it in the format of the if statement —  sum(if(Market = ‘Transient’, rooms, 0))

Mykhailo Halaida Mykhailo Halaida Flexmonster June 3, 2021

Hi Tom,
Flexmonster does not allow comparing string fields in calculated values.
You can, however, use some workaround, for example: create an additional numeric field indicating whether the room is transient and use it for the calculated value.
Here’s a JSFiddle sample illustrating this approach: https://jsfiddle.net/flexmonster/q9xpc6o7/.
Is this similar to what you’re looking for?

Please login or Register to Submit Answer