topic Re: num function in App Development

num function

awalhashim — Sat, 16 Nov 2024 06:47:15 GMT

Hi all,

based on my code, which part is wrong when i tried to change the format of number.

=If(Bookings.Event = 'Sign' and Type='Digital',
Num(sum({<Source__c=>}
if(SystemMapping.Group = Interest.Business_Unit,
if(CreatedDate < EventDate,
if(EventDate-CreatedDate > 0
and EventDate-CreatedDate < 365
Aggr(Only({<SaleID = e({1<Bookings.Event = {'Return'}>})>}SellingPrice),saleid),'RM #,##0.0 mil;(RM #,##0.0) mil'))))))

I tried to find a way but is not working

Re: num function

anushree1 — Wed, 23 Jan 2019 08:30:19 GMT

Could you try this,

=If(Bookings.Event = 'Sign' and Type='Digital',
Num(
if(SystemMapping.Group = Interest.Business_Unit,
if(CreatedDate < EventDate,
if(EventDate-CreatedDate > 0
and EventDate-CreatedDate < 365
Aggr(Only({<SaleID = e({1<Bookings.Event = {'Return'},Source__c=>})>}SellingPrice),saleid),'RM #,##0.0 mil;(RM #,##0.0) mil'))))))

Re: num function

pasi_lehtinen — Wed, 23 Jan 2019 08:33:55 GMT

Hi,

Your issue is related to the parantheses mostly. Anyways, you could also simplify your expression. Please try:

=num(
	If(
    	Bookings.Event = 'Sign' and Type='Digital'
		and SystemMapping.Group = Interest.Business_Unit
		and CreatedDate < EventDate
		and (EventDate-CreatedDate) > 0
		and (EventDate-CreatedDate) < 365,
		sum({<Source__c=>} Aggr(Only({<SaleID = e({1<Bookings.Event = {'Return'}>})>}SellingPrice),saleid))
	)
,'RM #,##0.0 mil;(RM #,##0.0) mil')

Also, this one could further be simplified by inserting all those if statements into the set analysis.