Forum Discussion

andrew's avatar
andrew
Cloud Apps
01-12-2024

Trying to use the Contribution() function with PASTYEAR() data results in error

Has anyone been able to use the contribution() function in conjunction with PASTYEAR()? in PIVOT2 E.g. we have CONTRIBUTION( [ Sales ] ) working fine but attempting CONTRIBUTION( PASTYEAR( [ Sales ]...
dashboards & reporting
david-h's avatar
david-h
Cloud Apps
01-12-2024

Hi Andrew,

which version of Sisense are you using ? With 2023.9, this formula :

Contribution(pastyear([Total QteVenteRetail1]))

works perfectly.

Best, David.