Forum Discussion
harikm007
08-11-2022Data Warehouse
Hi jirazazabal ,
If you need to get values from all dates, you can use ALL function (https://documentation.sisense.com/docs/function-references#all).
For example, to get total Sales Amount from all purchase date, use below formula
(SUM([Sales Amount]), ALL([Purchase Date]))
Is that what you are looking for?
-Hari
- jirazazabal08-11-2022Cloud Apps
Hi harikm007
I've tried to do it, but in contribution, YTD... seems desn't work. I get en ERROR in the FOrmula when appling this calc, or I get no data in all the columns...
Thanks
- harikm00708-11-2022Data Warehouse
Can you share the formula you were trying and the actual calculation you need?
-Hari
- jirazazabal08-11-2022Cloud Apps
Two metrics:
YTDSum([Total Bin_Suscrip_Act_Instal (1)]) Contribution([Valor (1)])