Get Free Trial

Filtered values in calculated values

Answered
Mark Waller asked on June 1, 2021

Hi,
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.
Thanks,
Mark.

3 answers

Public
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,
Mykhailo

Public
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))

Public
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?
 
Regards,
Mykhailo

Please login or Register to Submit Answer