Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings, please take a look to the following expression:
Sum({$<Month= {"{<=$}(=Max(Month))"}, Year= {$(=max(Year))} } Value)
I want to calculate the sum of the values of all months till our selection from the current year, for example if our selection is april, i want to sum the values from jan, feb, mar, apr.
Regards, Simão Ribeiro
Sorry Missed this -> "<="
Sum({$< Month = { "<=$(=Max(Month))" }, Year = { "$(=Max(Year))" } >} Value)
hi this seems right
Sum({$<Month= {"<=$(=Max(Month))"}, Year= {$(=max(Year))} } Value)
Sum({$<Month= {"<=$(=Max(Month))"}, Year= {"$(=max(Year))"} } Value)
Hi
try:
Sum({$<Month= {"<=$(=Max(Month))"}, Year= {"$(=max(Year))"} } Value )
Try this:
Sum({$< Month = { $(=Max(Month)) }, Year = { $(=Max(Year)) } >} Value)
Thanks,
V.
Hi,
Try this
Sum({$<Month = {"<=$(=Max(Month))"}>} Value)
Sorry Missed this -> "<="
Sum({$< Month = { "<=$(=Max(Month))" }, Year = { "$(=Max(Year))" } >} Value)