Arithmetics functions in text widget

Question

Hi,

I need to display a variance of sales so i need to do this operation:

(Sales2018-Sales2017)/Sales2017

How can i do it ?

i tried to create two datasets : sales2018 and sales2017 but i can't apply mathematics functions in text widget

Any idea ?

Answer 1

Hi Rahma,

you need to create one specific dataset with all measures you need and pass them in the text widget.. 

Besides, there is the possibility to apply some functions as sum or average, but it is not possible to create computed fields (cause operations like +,+,/,* are not available).

https://www.knowage-suite.com/qa/?qa=blob&qa_blobid=9135060004450333488

Regards,

Nunzia

Comments

İs there an option to apply conditional formatting to the values inserted in a text widget?