Wijmo Flexsheet - How to get dropdown value inside formula

Wijmo Flexsheet - How to get dropdown value inside formula

Posted by: khaja.razi on 9 June 2020, 4:21 pm EST

• 

  khaja.razi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 June 2020, 4:21 pm EST

  Hi,
  
  So i built datamaps to show the dropdown in the flexsheet.Scenario is like this. Dropdown displays values like ‘low’,‘high’,‘very-high’ for humidity column.So for each value selection , when i debug and check the collectionView the corresponding value is getting reflected. Example if i select ‘low’ its 0. So this is fine but i have an other column called total in which i want sum the value of this column and other column(temperature which is configured same as humidity like having dropdown) . So when i set the formula as ‘=Sum(B:C)’ output is ‘#Name?’. I even tested just to include the value of single column like ‘=B’ it gives the display value “low” but not corresponding value 0. Need your help in this

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 10 June 2020, 7:49 am EST

  Hi,

  The flexsheet uses the display values to evaluate the formulas because sometimes, the original value is also a formula so it cannot be used and needs to be converted into evaluated value.
  
  But, I have asked the developers whether there is a way to change this. The internal tracking id of the case is 440291. I will update you once I will hear from them.

  Regards,
  
  Ashwin

• 

  khaja.razi

  • Post Options:
  • Link
    Copy

  Posted 10 June 2020, 2:00 pm EST

  Thanks for your reply.It means a lot. I will indeed wait for status on this issue.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 20 May 2021, 12:57 am EST

  Hi,

  We are sorry for the delay in response. The only way to achieve this is to create a custom function that converts the datamap display value to key value. Please refer to the sample link below:

  https://stackblitz.com/edit/angular-hrlrw3

  ~regards