Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm new to CV and trying to sum a value if another 2 values are meet, it does not work !!!
My formula is as follow
sum({$<month.budget.date = monthsig, year.budget.date = yearsig>} SUM in expressios on statement)
which translate in if my budget dates (month.budget.date and year.budget.date ) match by signature date (monthsig and yearsig) , then I would like top plot the TCV (contract value)
You have to make sure that your date fields have the same format.
Contract Value would be the field you want to calculate
sum({$<month.budget.date = {"monthsig"}, year.budget.date = {"yearsig"}>} [Contract Value])