Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, @ Franky_h79 Andrey_krylov
i am using
below expression its working fine in listbox. where as rate filed is coming from database directly.
=Aggr(Only({<[Rate] = {"<=0.97>=1.03"}>} [ Code]), [ Code]) [listbox expression]
but now the issue is rate column is not coming from db . so we need to caluclate on the fly.
so i used this in the script to caluclate rate
Num([ AmountB]/[ AmountA], '#,##0.00%') as [Rate],
so now my requirment is ... i want to replace the rate with above expression to be used in listbox.
=Aggr(Only({<[Rate] = {"<=0.97>=1.03"}>} [ Code]), [ Code]) -- here how can place rate exression instead of direct rate
thanks
sony
I'm pretty sure this works:
=Aggr(Only(If([Net Sales Order US Dollar Amount Yotta]/[Net Sales Order US Dollar Amount CDR]<=0.97 or [Net Sales Order US Dollar Amount Yotta]/[Net Sales Order US Dollar Amount CDR]>=1.03, [Business Area Code])), [Business Area Code])
I think this is what you are looking for if you don't want to reproduce the original listbox.
=Aggr(
If(
SUM([Net Sales Order US Dollar Amount Yotta])/SUM([Net Sales Order US Dollar Amount CDR])<=0.97
or SUM([Net Sales Order US Dollar Amount Yotta])/SUM([Net Sales Order US Dollar Amount CDR])>=1.03,
[Business Area Code]
)
,[Business Area Code],[Fiscal Year Month Code],[Profit Center Level 0 Name]
)
Hi Tresesco any solution?
thank you Mikevwang list box it is working but in text box its showing wrong count.
the same expresision how can i modify in text object to get the listbox count?
='# of Match rate Red Count:'& chr(13) &sum( aggr( IF(SUM([Net Sales Order US Dollar Amount Yotta])/SUM([Net Sales Order US Dollar Amount CDR])>0.97 and
SUM([Net Sales Order US Dollar Amount Yotta])/SUM([Net Sales Order US Dollar Amount CDR])<1.03,0,1),[Business Area Code],[Fiscal Year Month Code],[Profit Center Level 0 Name]))
how to put comments like and helpful ? like earlier community wise ?
Hi,
i want to show the codes where the match rate is null that codes should show in the listbox how can i modify the expression in listbox?
include - SUM([Net Sales Order US Dollar Amount Yotta])/SUM([Net Sales Order US Dollar Amount CDR]) =null or 0
=Aggr(
If(
SUM([Net Sales Order US Dollar Amount Yotta])/SUM([Net Sales Order US Dollar Amount CDR])<=0.97
or SUM([Net Sales Order US Dollar Amount Yotta])/SUM([Net Sales Order US Dollar Amount CDR])>=1.03 ,
[Business Area Code]
)
,[Business Area Code],[Fiscal Year Month Code],[Profit Center Level 0 Name]
Hi Tresesco how can i include if match rate is null i want to show that codes in the listbox
Sorry, I could not follow your requirement.