Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As simple as =sum([Invoice Value]) for the total value, but i need this for the current month/year.
I can easily acomplish this by using the Actions (Select in field =month(vToday) and =year(vToday))
but i would like for this value to display automatically, like i have for value such as pending quotes etc (=sum({<[Quote Status]={'Pending'}>}[Quote Amount]))
Is this possible to do?
Hi
This hould do it
sum({<Month={"$(=Month(vToday))"}, Year={"$(=Year(vToday))"}>} [Invoice Value])
Regards
Jonathan
=sum({<month={"$(=vMonth)"}, year={"$(=vYear)"}>}, invoice Value)
where
vMonth=month(today())
vYear=year(today())
Try this
Hi
This hould do it
sum({<Month={"$(=Month(vToday))"}, Year={"$(=Year(vToday))"}>} [Invoice Value])
Regards
Jonathan
Thanks Jonathan