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.
⋅ 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
⋅ 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))
⋅ 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
