Expression to calculate net sold quantity

[sakshikaul]

Hi all,

I have a querry regarding creating a sell through report. Following is the expression which shows the comparison between two seasons

=sum({stateperA< [Season Code]={'17A'} >} quantity_sold)

- sum({stateperA< [Season Code]={'17A'} >} quantity_returns)

Following above code is giving correct result but I want the user should have a freedom to select any season code so how to write an expression for the same ?

[Anil_Babu_Samineni]

May be use like Implicit Set Operators‌

sum({stateperA< [Season Code]/={'17A'} >} (quantity_sold-quantity_returns))

[sakshikaul]

But I have to show comparison between two seasons so how is this possible without set analysis ?

[sakshikaul]

This is giving an error

[sakshikaul]

yes i can do that but I have to also show comparison between two year ie yaer 2017 and 2018 so in that case this above idea is not useful

[sakshikaul]

Hi

according to me i can get solution from this expression but this expression is not giving any result its giving 0 as value so please help what could be done?

[sakshikaul]

Hi

Here is my expression for sold (QTY)(CY). The following expression is not giving result

=sum( {stateperfB<  Sold_Date = {">=$(From)<=$(To)"},[Season Code] = {$(Master_CurrentSeason)} >} quantity_sold)- sum( {stateperfB< Sold_Date = {">=$(From)<=$(To)"}, [Season Code] = {$(Master_CurrentSeason)} >} quantity_returns)

[Anonymous]

Hi,

if Season Code is having space in it so you have to mention the Season Code Field in single quotes

eg['Season Code'].

Regards

Ritesh

[balabhaskarqlik]

May be use this:

=sum({<stateperA=p(stateperA), [Season Code] = {"$(=getfieldselections([Season Code]))"} >} quantity_sold)

-

sum({<stateperA=p(stateperA), [Season Code] = {"$(=getfieldselections([Season Code]))"} >} quantity_returns)