How do I create this excel calculation in CV?
Hi All, I'm creating this report which uses a custom formula, that takes SUM/AVG of past six months, and calculates the Pct value. I tried using Rolling6MonthTotal and Rolling6MonthAvg view dimensi...
Forum Discussion
Hmm, a basic GetDataCell should work for this. It would look like:
GetDataCell(Divide(A#RentalRevenue:V#Trailing6MonthTotal, A#Fleet:V#Trailing6MonthAvg)*2):Name(YourCalc)
Italicized should be replaced with correct member names.