Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to calculate only the Total row for Price For KM by the following way - Last (KM) / Last(Cumulative Amount) -
The formula for 'Price For KM' is (KM/ Cumulative Amount)
Sample Date:
* In the original I present in a straight table
What is the way to do it? I tried several ways, I get NULL in Total line
Thanks
Try something like : Bottom("Price For KM") or Bottom("KM"/"Cumulative Amount") both should work.