topic Re: Adding two values with respect to date conditions at backed script in App Development

Adding two values with respect to date conditions at backed script

Aspiring_Developer — Sat, 16 Nov 2024 01:35:29 GMT

Hello everyone,

I am trying to achieve the below:-

If("Calendar Year" <= Year(today()), Actual) + if("Calendar Year" >=year(today()), RB) as Hours

Is this correct to calculate the dimension at backend.

I want to create a dimension "Hours" using this conditon

Hours = “actual” hours when Year < Today + “RB” hours when Year >= Today

Pleas help

Re: Adding two values with respect to date conditions at backed script

Taoufiq_Zarra — Wed, 26 Aug 2020 10:42:26 GMT

can you share a sample data and if possible the expected output ?

Re: Adding two values with respect to date conditions at backed script

Kushal_Chawda — Wed, 26 Aug 2020 11:08:45 GMT

You an create a Flag in script and then you can use it to create the measure

LOAD *,

if("Calendar Year" <= Year(today()), 1,2) as Year_Flag

FROM Source;

then you can use below measure in chart

=sum({<Year_Flag={1}>}Actual)+sum({<Year_Flag={2}>}RB)

Re: Adding two values with respect to date conditions at backed script

Aspiring_Developer — Wed, 26 Aug 2020 11:26:59 GMT

@Taoufiq_Zarra

Please see the data:-

LOAD

Actual,
If("Calendar Year" < Year(today()), Actual) + if("Calendar Year" > year(today()), RB) as Hours,
CB,
"CB - Unit",
RB

From....

Please help as i have deliver it next week

Re: Adding two values with respect to date conditions at backed script

Aspiring_Developer — Wed, 26 Aug 2020 12:22:29 GMT

@Kushal_Chawda

Mnay thanks Kush for your response.

But i have to create a dimension as "Hours" using this calculation at the backend. Could you please help me on that.

Many thanks again

Re: Adding two values with respect to date conditions at backed script

Kushal_Chawda — Wed, 26 Aug 2020 12:28:00 GMT

Assuming that you have all column in same table then try below in script You can then use the hour as a dimension

If("Calendar Year" <= Year(today()), Actual, RB) as Hours

Re: Adding two values with respect to date conditions at backed script

Aspiring_Developer — Wed, 26 Aug 2020 12:50:11 GMT

@Kushal_Chawda

Hello Kush , i wish to achieve this:

Hours = “actual” hours when Yearmonth < Today + “RB” hours when Yearmonth >= Today

We have to add them at the backend and display them as "Hours" in dimension.

Thanks

Re: Adding two values with respect to date conditions at backed script

Aspiring_Developer — Wed, 26 Aug 2020 13:02:41 GMT

Can anyone please help on this as it is very critical for me and i tried everything but not working.

@sunny_talwar

Re: Adding two values with respect to date conditions at backed script

Kushal_Chawda — Wed, 26 Aug 2020 14:33:02 GMT

It's really not clear what you are trying to do. did you check my last response?

Re: Adding two values with respect to date conditions at backed script

sunny_talwar — Wed, 26 Aug 2020 17:59:33 GMT

Not entirely sure, but may be this

RangeSum( If("Calendar Year" < Year(Today()), Actual), If("Calendar Year" > Year(Today()), RB) ) as Hours,

But what happens when Calendar year = Year(Today())? Right now both you are if statements don't include that condition. You might want to change one of the if statement logic to include =, either >= or <= depending on the value needed for current year