Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

functions

Answered
Paul Schlichter asked on July 31, 2018

What excel like functions can we use in formulae? Round? Roundup? Rounddown? Floor? Sumif? Concatenate?
Thanks

3 answers

Public
Tanya Gryshko Flexmonster August 1, 2018

Hello, Paul,
Thank you for writing to us!
Please click on Add calculated value button inside the Field List to see the pop-up window for adding the new value. Here you will see which operators can be used in the formula. Compose the formula by clicking on operators and dragging the existing values to the formula box.
Please inform me in case of further questions.
Regards,
Tanya

Public
Paul Schlichter August 1, 2018

Yes,  I am aware of the workings of the field list. Also looked over the API. It seems like the functions I am looking for are not available
 

Public
Iryna Kulchytska Flexmonster August 2, 2018

Hi Paul,
 
Thank you for letting us know that you double-checked the calculated values functionality and API.
The pivot table does not provide the functions you were asking about.
 
Kind regards,
Iryna

Please login or Register to Submit Answer