Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to sum the total where year =2022, productid -=19*, and trackingid-=98* can you please help write the set analysis?
if the productid starts with 19* then only I have to remove the trackingid which starts wiht 98* otherwise it has to include them.
Thanks and Regards,
Vinod.
= Sum({$<year = {'2022'}, productid -= {"19*"}, trackingid-= {"98*"}> } Sum_field)
Hi,
I have other trackingid starts with 98* which are comming form different productid's i have to include them.
JUST KEEP INCLUDING THEM IN THE EXPRESSION:
= Sum({$<year = {'2021', '2022'}, productid -= {"19*", "20*"}, trackingid-= {"97*", "98*"}> } Sum_field).
please provide some sample data and a picture of the desired output for more accurate solution.
@vinodmehar22 try below. Not sure which aggregation you would like to perform but below will be the set expression
Count({<productid={"19*"},trackingid-={"98*"}> + <productid-={"19*"}>}ID)
or
sum({<productid={"19*"},trackingid-={"98*"}> + <productid-={"19*"}>}Value)
@vinodmehar22 Missed the Year=2022,
sum({<PID={"19*"},tracking_id-={"98*"}> + <product_id-={"19*"},YEAR={'2022'}>}SALES)
@_Iswarya_ I assumed that we can select the year to get the results . But if it is just for year 2022 always then , more dynamic solution would be below assuming it is previous year
sum({<productid={"19*"},trackingid-={"98*"}, Year ={"$(=max(Year)-1)"}> + <productid-={"19*"},Year ={"$(=max(Year)-1)"}>}Value)