Get Free Trial

Add computed formula

Mantas asked on May 13, 2022

I’m going to buy this component. I’m testing if it can do what I need. Currently I stuck on creating pivot table with custom columns. I have data:
  {“ID”: 1, “Floor”: 1, “IsSold”: “true”},
  {“ID”: 2, “Floor”: 1, “IsSold”: “false”},
  {“ID”: 3, “Floor”: 2, “IsSold”: “true”},
  {“ID”: 4, “Floor”: 2, “IsSold”: “true”},
I need table:
Floor | Total per floor | Sold | Left | %
I can not find, how can I add conditional columns, like (“Sold”, “Left” and “%”).
I need something like: sum(if(“Sold” = “true”, 1, 0))
then: count(“ID”) – sum(if(“Sold” = “true”, 1, 0))
then: sum(if(“Sold” = “true”, 1, 0)) / count(“ID”)
But condition does not work like that. How can I work with conditions, which filters data by string value, but not number?

2 answers

Nadia Khodakivska Nadia Khodakivska Flexmonster May 13, 2022

Hello, Mantas,

Thank you for reaching out to us.

Currently, string comparison options for calculated measures are not supported in Flexmonster.
As a workaround, you could edit your data set by changing the values of the "IsSold" field. For example,

  {"ID": 1, "Floor": 1, "IsSold": 1},
  {"ID": 2, "Floor": 1, "IsSold": 0},
  {"ID": 3, "Floor": 2, "IsSold": 1},
  {"ID": 4, "Floor": 2, "IsSold": 1},

This way, you can use the new "IsSold" in your calculated values.

We hope it helps. You are welcome to write to us in case further questions arise.

Kind regards,

Mantas 7 days ago

I have translated file. All translations work except “Fields” window. None of English values are translated there. Is this is not translatable on purpose?
I does not work in German from too.


Nadia Khodakivska created a new ticket #45957 from this answer

Please login or Register to Submit Answer