0

Sum with multiple condition (dates and multiple choise field)

Hi, I searched a lot but found nothing that is right for me. I have this formula. Basically I would like to sum the expenses between one date and another but which have as their parameter a specific choice in a multiple choice field (for example: "Cars" or "Clothing"). I tried this formula but it's not good because as soon as I exit the formula window it changes the value:

let Da := Da;
let A := A;
sum((select Spese where (Data >= Da and Data <= A) and 'Tipo Uscita' = 7).Euro)

 

When I exit the window and return the formula has changed like this:

let Da := Da;
let A := A;
sum((select Spese where Data >= Da and Data <= A and A = 7).Euro)

 

Thnak you for your help

 

TRANSLATE with x English Arabic Hebrew Polish Bulgarian Hindi Portuguese Catalan Hmong Daw Romanian Chinese Simplified Hungarian Russian Chinese Traditional Indonesian Slovak Czech Italian Slovenian Danish Japanese Spanish Dutch Klingon Swedish English Korean Thai Estonian Latvian Turkish Finnish Lithuanian Ukrainian French Malay Urdu German Maltese Vietnamese Greek Norwegian Welsh Haitian Creole Persian     TRANSLATE with COPY THE URL BELOW Back EMBED THE SNIPPET BELOW IN YOUR SITE Enable collaborative features and customize widget: Bing Webmaster Portal Back

Reply

null

Content aside

  • 2 yrs agoLast active
  • 157Views