topic Re: Get Field Selections Syntax with IF statements in App Development

Get Field Selections Syntax with IF statements

Milaf — Thu, 16 Nov 2023 20:28:19 GMT

Hi All,

I could not run the calculated field below, this is the logic but I am making a mistake somewhere.

=if(GetFieldSelections([Period])='Daily', sum({<DATE= {'$(vYesterday)'}>} IPCOUNT),
if(GetFieldSelections([Period]),'Weekly', sum({<DATE= {'$(vPreviousWeek)'}>}IPCOUNT)
if(GetFieldSelections([Period]),'Monthly',sum({<DATE= {'$(vPreviousMonth)'}>}IPCOUNT))))

Re: Get Field Selections Syntax with IF statements

MatheusC — Thu, 16 Nov 2023 20:39:25 GMT

Hi, @Milaf

try correcting the syntax like this

if(GetFieldSelections([Period])='Daily',sum({<DATE= {'$(vYesterday)'}>} IPCOUNT),
if(GetFieldSelections([Period])='Weekly', sum({<DATE= {'$(vPreviousWeek)'}>}IPCOUNT),
if(GetFieldSelections([Period])='Monthly',sum({<DATE= {'$(vPreviousMonth)'}>}IPCOUNT))))

Re: Get Field Selections Syntax with IF statements

Milaf — Fri, 17 Nov 2023 09:29:45 GMT

Thank you Matheus, I didn't notice the syntax there but I changed it when I saw it 🙂

Finally, I tried the one below, but the monthly one never works. I could not get the total of the previous month 😞

=if(GetFieldSelections([Period])='Daily',sum({<DATE= {'$(vYesterday)'}>} IPCOUNT),
if(GetFieldSelections([Period])='Weekly',sum({<DATE= {'$(vPreviousWeek)'}>} IPCOUNT),
if(GetFieldSelections([Period])='Monthly', sum({<MONTH= {'$(vMonthly)'}>} IPCOUNT)
)))

Re: Get Field Selections Syntax with IF statements

Milaf — Fri, 17 Nov 2023 09:58:57 GMT

My Monlty variable is;
=Date(MONTH-31, 'DD.MM.YYYY')

I wrote above "sum({<MONTH= {'$(vMonthly)'}>} IPCOUNT) " works when I write 01.10.2023 instead of the variable in the formula. "sum({<MONTH= {'01.10.2023'}>} IPCOUNT) but it does not detect the variable value even though it is correct.

Re: Get Field Selections Syntax with IF statements

MatheusC — Fri, 17 Nov 2023 11:39:49 GMT

@Milaf

try this in your variable

vMonthly
$(=Date(MonthStart(AddMonths(today(1),-1)),'DD.MM.YYYY'))

Re: Get Field Selections Syntax with IF statements

MatheusC — Mon, 20 Nov 2023 11:59:47 GMT

@Milaf

Close the topic and mark the solution as accepted

Thanks!

Re: Get Field Selections Syntax with IF statements

Milaf — Sun, 03 Dec 2023 10:00:48 GMT

This is the solution;

if(GetFieldSelections([Period]) ='Daily',
(sum({<Todayly= {'$(vYesterday)'}>} IPCOUNT1) + sum({<Todayly= {'$(vYesterday)'}>} IPCOUNT2) + sum({<Todayly= {'$(vYesterday)'}>} TotalCount)),
if(GetFieldSelections([Period])='Weekly',
(sum({<Todayly= {'$(vPreviousWeek)'}>} IPCOUNT1) + sum({<DATE= {'$(vPreviousWeek)'}>} IPCOUNT2) + sum({<Todayly= {'$(vPreviousWeek)'}>} TotalCount)),
if(GetFieldSelections([Period])='Monthly',
(sum({<Monthly= {'$(vAy)'}>} IPCOUNT1) + sum({<Monthly= {'$(vAy)'}>} IPCOUNT2) + sum({<Monthly= {'$(vAy)'}>} TotalCount))
)))