expressions help

[surajap123]

Hi Experts,

Could you help me how to write the expressions(using set analysis) for below-

1.select sales from table

where activitydate = today()

2. expression to get % of sales increase or decrease compare to previous day.

Regards,

Suraj

[vikasmahajan]

=sum( {$< Quarter=,Monthname=, FiscalYear={$(=Max(FiscalYear))}>} Sales)  This will current period sales

=sum( {$< Quarter=,Monthname=, FiscalYear={$(=Max(FiscalYear)-1)}>} Sales)  This will current period sales

=column(1)-column(2)./column(2)  formula for growth %

Hope this helps you.

Vikas

[Anonymous · Accepted solution]

1.

sum({$<activitydate = today() >} Sales)

2.

=num((sum({$<activitydate = date(Today()) >} Sales) - sum({$<activitydate = date(Today()-1) >} Sales))  /

          sum({$<activitydate = date(Today()-1) >} Sales),'0.00%')

Hope it helps

BR,

CA

[#4]

will u please share example data

so i can help more accurately