Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If( [Type] = 'A' , -1 * [Volume] * NUM([ Rate]) )
now i want to add contract year field in the expression
so basically if type is A and contract year is following calculate the year value.
so i have a table with
2016 12.4
2017 52.2
2018 12.12